How do I automatically fill a cell based on another cell in Excel

[Guest]

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?

 

[Guest]

Yes,
I assume you already have a price for every part in the list somewhere. So
what you need is a VLOOKUP formula.

=VLOOKUP(A1,your range, 2,0)
A1 is the cell with the drop down list
your range - range where you have your part list in one column and the
corresponding price in another column.
2 is the price column, in this case it would be the second column in your
range.


HTH
JG

 

[Guest]

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

HTH,
Elkar

 

[Guest]

Thanks for the help. It worked perfectly.

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

HTH,
Elkar