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?