2nd column of the data range.. If your data range has got 10 columns and you
want to return the 8th column info, specify that as 8
--
If this post helps click Yes
---------------
Jacob Skaria


"dragons_lair" wrote:

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