VLOOKUP returns #N/A

[tsukami]

I'll attach the workbook, in the invoices worksheet, column D you'll see that most of the column is N/A, I can't figure out where it went wrong.

[ashleyuk1984]

You haven't locked your ranges. Easy mistake to make.

Go to Cell D4 (Your first vlookup formula) on your INVOICES tab... and left click on A4 in your formula, and press F4, do the same with B7 in the formula...
Your formula will now look like:

=VLOOKUP(C4,Commission!$A$4:$B$7,2,FALSE)*F4

Notice the dollar signs. This means that when you drag the formula down, these cells WONT change now... This is why you were having the #N/A problem before.

[tsukami]

thankyou