Try: Tools Formula Auditing Evaluate Formula.


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Robbo12" wrote:

Hi all
I am having trouble with a logical test. I have sheet A which i want cell B1
for example to search sheet B for an exact match to Cell A1 on sheet A and
return True if found and false if not found. I have tried several times and
the IF function seems to only return a FALSE expression. The formula im using
is
=IF(SheetB!B1:B530=A157,"True","False")

This formula is entered into Sheet A

Can someone please help with why it only returns the FALSE when the data
clearly contains the info im searching for.