True/false statements checking for range

  • Thread starter Thread starter krayziez
  • Start date Start date
K

krayziez

I'm able to check for single cells like:
=A1=B1

But how do I do it so I can check if A1 equals from B1 to B10 ? For
example, A1 is:
Dog

B1-B5 is:
Cat
Dog
Brick
House
Towel

I tried this but it didnt work:
=A1=B1:B5

It shows as false. Is there a function for true/false that's better
than just equal?
 
=ISNUMBER(MATCH(A1,B1:B10),0)

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
 
One more <bg>:

=ISNUMBER(MATCH(A1,B1:B10,0))



Bob said:
=ISNUMBER(MATCH(A1,B1:B10),0)

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)
Click to expand...
 

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

Cell colour change if formula displays false 3
check value in cell 2
Formula Query 9
Non-VBA to gow grow based on another cell? 3
if statement true=now false retains last true 3
Comparing Dates 5
Displaying a range based on a cell's contents 3
Data Validation and drop-down list using IF, AND and what else? 8

Back
Top