How do i trouble shoot an IF function

R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula 1
How to check if time falls between two ranges 0
How do I write an IF function using dates? 2
MATCH not working in IF statement 6
return date from range of dates with if statement 3
Vlookup and return sheet name also 2
lastrow function help 6
VLOOKUP Function to return values in multipal Columns 6

Top