Thanks for all the info much appreciated and solved my problems
--
Dragonette


"L. Howard Kittle" wrote:

As Jacob said, the 2 is the column to return. The fourth argument 0 asks
for an exact match. You can use FALSE or 0.

If you omit the fourth argument OR use 1 or TRUE, then if there is no match
the formula will return the nearest match that is less than the lookup
value.

HTH
Regards,
Howard

"dragons_lair" wrote in message
...
Thanks so much saved me hours of heartache, works like a charm. Just
another
dumb question for you what is the 2,0 on the end of the formula for?
--
Dragonette


"L. Howard Kittle" wrote:

I believe that can happen...

You will have to list the product codes in one column and the desired
descriptions in the next column. Can be anywhere on the sheet and even
on a
different sheet.

So with Product Codes in column D1:D10 and descriptions in E1:E10...

Then in the cell you want the returned result you would enter a formula
like...

=VLOOKUP(A1,D1:E10,2,0)

Where A1 is the lookup_value.

HTH
Regards,
Howard



"dragons_lair" wrote in message
...
Can I use data validation to populate 2 cells.

I select the product code from list and it fills out the product
description
in correspondening cell as well.

--
Dragonette