You need to use VLOOKUP.. Please find the below example

Suppose you have data in Col A and Col B
ColA ColB
1 One
2 Two
3 Three

C1 = Product Code (example 2)
In D1 enter the below formula ;should return the text "Two"
=VLOOKUP(C1,$A$1:$B$10,2)

If this post helps click Yes
---------------
Jacob Skaria


"dragons_lair" wrote:

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