Hi

I am trying to get this formula to work, but its giving me an incorrect value-

=IF(XMATCH($E2,All!E:E,0)=XMATCH($B2,All!B:B,0),"All!E"&XMATCH($E2,All!E:E,0),FALSE)

The expected answer should be the value stored in All!E210

Actual answer is the text value of "All!E210"

How can I fix this. This has been driving me crazy for the last 2 days!! Please help!!