Hi LSimon. I think this site has what you're looking for:
http://www.contextures.com/xlDataVal02.html. HTH
--
Sincerely, Michael Colvin


"LSimon" wrote:

I have two named lists, one containing vendor names and the other containing
vendor numbers. When a user selects a vendor name from the drop down box in
column B I would like the vendor number to populate in column A. How do I do
this?