I would like to raise the price of certain items by the amount found on Sheet2 in Column C. I would like all prices that don't match these UPC codes to remain unchanged and I would also prefer to have the new changed numbers to appear in there original Column C on Sheet1. Intended Results can be seen on Sheet1. Not sure if I should use the Vlookup function or a macro, or maybe there is even a better solution.
Spreadsheet may be viewed/edited at http://spreadsheets.google.com/ccc?key=pT0dg5ZEHWLMyhNJLiPLTfA.
Also, both sheets can be seen below:
Spreadsheet may be viewed/edited at http://spreadsheets.google.com/ccc?key=pT0dg5ZEHWLMyhNJLiPLTfA.
Also, both sheets can be seen below: