Vlookup worked great. I was able to retrieve the correct data.
However, in the cells next to the column of cells that contain the
returned data, I have a simple multiplication formula. When these cells
are empty, #VALUE! appears. The problem is that I can not add the cells
that contain the multiplication formula together when one or more cells
contain #VALUE!.

Is there something in the vlookup formula that may be causing this?
There is no text in the data being retrieved, only numbers. I used the
vlookup formula exactly as you gave it to me in your example.

Thanks for your help.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!