check out this site, it's just what you are looking for
this shows how to use VLOOKUP
http://www.contextures.com/xlFunctions02.html
This shows how to add names to a list, which you could then use for a
dropdown menu in your vlookup
http://www.contextures.com/xlNames01.html#Dynamic
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=539144