Thanks so much, saved me lots of heartache and I got it to work.
--
Dragonette


"Jacob Skaria" wrote:

Alternatively if you are looking at conditional lookup refer the below link

http://www.contextures.com/xlDataVal13.html
--
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