Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
update selected table values
table 1 col a item name, col b sales price
table 2 has new prices for just selected items how do I automatically replace the old prices in table 1 with new from table 2? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
update selected table values
Near table 1, col C:
=IF(ISERROR(VLOOKUP(A2,Table_2,2,FALSE),B2,VLOOKUP (A2,Table_2,2,FALSE)) Then do a copy, paste special - values -- Best Regards, Luke M "BlackBayou" wrote in message ... table 1 col a item name, col b sales price table 2 has new prices for just selected items how do I automatically replace the old prices in table 1 with new from table 2? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Formula Needed to Update Table Values | Excel Discussion (Misc queries) | |||
Conditional formatting won't update until cell is selected: Excel | Excel Discussion (Misc queries) | |||
Selected Sheet will update cell. | Excel Discussion (Misc queries) | |||
workbook update each time a new worksheet is selected | New Users to Excel | |||
Update workbook each time a different worksheet is selected | New Users to Excel |