URGENTTTTTTTTT!!!! I REALLY NEED HELP - VLOOKUP

[Sami]

I have created a VLOOKUP for searching for the product name in the product workbook when the product ID has been entered:

=VLOOKUP(ProductID,Products.xls!ProductTable,1,FALSE)

However although this should work i dont know why it keeps coming back with #NA
????

 

[Chris Davison]

there ya go.... well done Sami !


(not sure I can help much on the others, they're not really stuff I deal with enough to be able to advise on)

 

[Paul-Johnson]

Check your e-mail

I never received your files. But, I sent you my sample based on your post

 

[dtaylor]

i have had the same problem. if you are doing a vlookup in the same workbook you will need to create abolute references..

ex.

vlookup(cell,$cell$:$cell$,1,false)

or you could try a values(trim()) formula on each column of data. i have found when i do this to each column (on both sources) the vlookup works.