Thanks for the help. It worked perfectly.

"Elkar" wrote:

Yes, the VLOOKUP function will do this. Look at the examples in the Help
file. Post back if you need further help.

HTH,
Elkar

"SouthCarolina" wrote:

I am trying to fill an adjacent cell based on the input in another cell.
Here are the particulars. I have created a pull down list in one cell. The
list contains all of the parts that our mechanics order. Now when one of the
parts are chosen I would like for Excel to populate the next cell over with
the price of the part automatically. Can this be done?