PDA

View Full Version : VLOOKUP returns #N/A



tsukami
03-07-2014, 07:10 PM
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
03-07-2014, 07:53 PM
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
03-07-2014, 08:33 PM
thankyou :)