Start by checking the Dependent Lists section of Debra Dalgleish's website:

http://www.contextures.com/xlDataVal02.html


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"chris100" wrote:


Hi all,

This is either incredibly easy problem or very hard - i've searched for
an answer here and elsewhere but with no luck.

Basically, i need a pull down list that references two columns but only
uses the data in the first column for data entry.
The reason is i may have the same products from different suppliers so
need to differentiate between them.

So in case i didn't explain clearly enough - First column in the
pulldown list would be "Product", second column would be "Supplier."
Both would be visible in the pull-down list, only the product would be
entered in the cell.

Any help would be much appreciated, as always,

Thanks,

Chris


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=499022