update selected table values

  • Thread starter Thread starter BlackBayou
  • Start date Start date
B

BlackBayou

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?
 
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
 
Back
Top