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")


"tdoughty" wrote:


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

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

Any help will be greatly appreciated.


--
tdoughty
------------------------------------------------------------------------
tdoughty's Profile: http://www.excelforum.com/member.php...o&userid=29616
View this thread: http://www.excelforum.com/showthread...hreadid=493180