If statements

T

tdoughty

I need help with an if statement. I have two seperate columns that
need to compare. I need to compare each value in one column to all th
values in the other column to see if I have any that match. What shoul
my formula look like?
For instance I'm comparing column B with column Q and using th
following formula but it is not working.

=if(or(B1=$Q$1:$Q$150),"Yes","")

Any help will be greatly appreciated
 
B

bpeltzer

You could use a MATCH function to see if b1 is anywhere in Q1:Q150:
=if(isna(match(b1,$Q$1:$Q$150,false)),"","Yes")
 
Top