| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically fill a cell based on another cell in Excel
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I automatically fill a cell based on another cell in Excel
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 "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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I automatically fill a cell based on another cell in Excel
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I automatically fill a cell based on another cell in Ex
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to fill the cell color based upon the other cell condition | Excel Discussion (Misc queries) | |||
| Can I fill colour in a excel cell from a return from an "IF" test. | Excel Worksheet Functions | |||
| Automatically save file based on cell value | Excel Discussion (Misc queries) | |||
| In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Hybrid Mode
