update selected table values

[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?

 

[Luke M]

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