Use VLOOKUP or INDEX/MATCH
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
http://www.ozgrid.com/Excel/left-lookup.htm



--
Regards
Dave Hawley
www.ozgrid.com


"Clay H" <Clay wrote in message
...
I have a template for filling out quotes and I was looking to create a drop
down menu with all of the names of customers that I regularly send out
quotes
to (it's about 20 people). I have figured out how to make a drop down list
with a bunch of names but I would like it so that when I select a name
from
the drop down menu, the customers contact info pops up on the quote under
the
name. Is this even possible?

Thanks!