You can use the Vlookup() function.

Check here and post back with any questions:

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

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"msm89" wrote in message
...
I am trying to retun a value for a cell based on another cell that will have
approx. 100 possible values. The first cell is a list of vendor names
(which
I have in a drop down menu) and the second is a vendor # (which will always
correspond to a specific vendor name). I would like the vendor # to
automatically fill in depending on which vendor name I choose from the drop
down vendor list.

Any help is much appriciated,

msm89