IF statement but to add = formula if true.

[akeem1234]

Hi guys,

This one is quite simple but i am unsure how to work this.
I have two data sets but one is the previous week and one is the new versions
i want to find out the difference between the two values but some of the data from previous week is not in there so i need to match them using the VLOOKUP and if the value is there then run the difference between the two figures from the specific column

my formula was: IF(A2=VLOOKUP(A2,OLD!A:A,1,0),"=C2-OLD!C2","")

the only issue is, instead of true statement doing The sum of C2- C2(PREVIOUS DATA SHEET), it populates the formula as text =C2-OLD!C2.

So i need to know how i can make that formula populate the result between the two figures and not as an actually statement

 

[Fluff]

This part "=C2-OLD!C2" should be C2-OLD!C2

 

[akeem1234]

Absolute legend!!, thank you Sir.

 

[Fluff]

You're welcome & thanks for the feedback.