Column A sheet 1 has codes and corresponding prices in column B. Column A sheet 2 has the same codes but with different $$ (column B). Column C Sheet 1 should have a formula calculating what % of a new price is the old price. I assume it should be a v-lookup formula first to look up a code, but I am not sure how to add a % calculation after that.
Please see the attached file.