VLOOKUP

[Guest]

I need some help. I am trying to make an invoice that when I type in the
product number, the description and unit price appear in the next two
columns. I did the same thing with the address and it works just fine.
However, it will not work with the product number. When I type in the
product number the desciption and unit price column both show#REF.

I don't understand why this keeps happening. Can someone please help me?
Thanks in advance.

By the way, I would be happy to e-mail this workbook if someone would like
to take a look at it.

 

[Anne Troy]

Your values likely differ. For instance, one may be formatted as text, and
the other as numbers. You can use the format painter to make sure they're
formatted the same. Try retyping one of the numbers---both the one being
looked up (see if that helps) and then the one in your lookup list (see if
that helps). If doing either helps, then use the data fix described here
under "Data isn't recognized..."
http://www.officearticles.com/excel/data_cleanup_tips_for_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com