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
????

 

[Paul-Johnson]

if you are comfortable with e-mailing me the data or a subset I will take a look for you

 

[Sami]

yeah sure can i do it now?

 

[Paul-Johnson]

yes - I just made a sample that I will send you as well.

<email removed>

 

[Sami]

hey have u got msn messenger????

 

[Paul-Johnson]

no - i only have aol messenger

_________________
Paul

what is your e-mail address i will send you my sample
This message was edited by Paul-Johnson on 2002-03-16 10:33

 

[Sami]

im sending it now the files 2 u
thanks

 

[Paul-Johnson]

i never got your files or your e-mail.

If you want the sample I set up send me your e-mail address.

 

[Sami]

i sent you the files!?
thanks

 

[Sami]

YYYYYYYYY doesnt this code work????

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

it should work?

 

[Sami]

i get what you mean about the first column now. is there any way around this problem ? bcos ive already done so much testing?? plz help