software

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?

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

quot;SouthCarolinaquot; wrote:

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

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

HTH,
Elkar

quot;SouthCarolinaquot; wrote:

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

Thanks for the help. It worked perfectly.

quot;Elkarquot; wrote:

gt; Yes, the VLOOKUP function will do this. Look at the examples in the Help
gt; file. Post back if you need further help.
gt;
gt; HTH,
gt; Elkar
gt;
gt; quot;SouthCarolinaquot; wrote:
gt;
gt; gt; I am trying to fill an adjacent cell based on the input in another cell.
gt; gt; Here are the particulars. I have created a pull down list in one cell. The
gt; gt; list contains all of the parts that our mechanics order. Now when one of the
gt; gt; parts are chosen I would like for Excel to populate the next cell over with
gt; gt; the price of the part automatically. Can this be done?