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.