If you refer to a cell with a formula in another formula it will use the
value and not the text string of the formula


--
Regards,

Peo Sjoblom



"Soz" wrote in message
...
I'm using a basic IF formula =IF(j2=i2,"yes","no") but i2 has a Vlookup
formula. Can I use the If statement above to use the value of the formula
and
not the formula?