Here it is,

=VLOOKUP(A17,'PRODUCT INFO'!A2:D674,2,FALSE)


"Farhad" wrote:

Hi,

I need to see your VLOOKUP formula.

Thanks,
--
Farhad Hodjat


"Bonnie" wrote:

I have made a form and inserted VLookups. In my list of products there is
more than one of that product name but different sizes. So it looks like this:

Product name Item # Discription Unit of measure
Buccaneer Plus #00521 2x2.5ga ju ga
Buccaneer Plus #00522 30ga drum ga
Buccaneer Plus #00523 Bulk ga ga

So then I made a drop down list from the product name and everything else
fills in itself because of the vlookups I put in.

The problem is it only recognizes the first product name and number.

How can I fix this? What should I do different?