How do i trouble shoot an IF function

[Robbo12]

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.

 

[T. Valko]

=IF(SheetB!B1:B530=A157,"True","False")

One way:

=COUNTIF(SheetB!B1:B530,A157)>0

 

[ryguy7272]

Try: Tools > Formula Auditing > Evaluate Formula.


HTH,
Ryan---