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.

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

One way:

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

--
Biff
Microsoft Excel MVP


"Robbo12" wrote in message
...
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.

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.