Use IF formula to reference data within a formula?

[tvalcorn]

Hi All,

Is it possible to search the data within a formula rather than the text that the formula produces?

I would like to return a value if a cell references a specific cell.

i.e. =IF({A2 references C2},"Yes","No")

Thanks in advance!!!

 

[RatExcel]

Try to play with this. It will work however is not 100% functional as it will also return "Yes" if A2 references C22 or AC2. Now I do not have time to provide a final solution, but at least you have a starting point. I will try to post final solution later today.

=IF(IFERROR(FIND("C2",FORMULATEXT(A2)),0),"Yes","No")

 

[tvalcorn]

Thanks RatExcel!

I played around with it a little more and have come up with this:

=IF(ISNUMBER(SEARCH(CELL("address",$C$2),FORMULATEXT(A2))),"YES","NO")

which works. but not sure if I've made it harder than it needs to be...