| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating cell data from a table with an ID
I have a table called hinnakiri which has a lot of rows and 3 columns with
headers (Material, Price, Other Price) And I have a column where I can select material name from a DataValidation drop-down listbox.. I need to update the cell next to it with a price from hinnakiri. I need the price to update automatically in that cell every time I change it in hinnakiri. How is it possible? :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Updating cell data from a table with an ID
Use VLOOKUP:
Assume DV is in cell A2 and price in B2: in B2: =VLOOKUP(A2,hinnakiri,2,0) HTH "MadHenry" wrote: I have a table called hinnakiri which has a lot of rows and 3 columns with headers (Material, Price, Other Price) And I have a column where I can select material name from a DataValidation drop-down listbox.. I need to update the cell next to it with a price from hinnakiri. I need the price to update automatically in that cell every time I change it in hinnakiri. How is it possible? :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Pivot Table Data automatically from external workbooks | Excel Discussion (Misc queries) | |||
| Data table is not updating correctly in excel 2003 | Excel Discussion (Misc queries) | |||
| updating a table | Charts and Charting in Excel | |||
| updating pivot table | Excel Discussion (Misc queries) | |||
| Updating a table...can this be done? | Excel Discussion (Misc queries) | |||
Linear Mode
