# vlookup formula that additioanlly calculates a % of a value

Hi!

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.

thx
To-find-a-percentage-of-a-value-through-
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
try this formula:
=IF(ISNA(VLOOKUP(A2,Sheet2!A1:B8,2,FALSE)),0,Sheet1!B2/VLOOKUP(Sheet1!A2,Sheet2!A1:B8,2,FALSE))
Commented:
Apply this formula in C2 and drag it...

=(VLOOKUP(A2,Sheet2!\$A\$2:\$B\$8,2,0)/B2)-1

Saurabh...

Experts Exchange Solution brought to you by