software

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),quot;Yesquot;,quot;quot;)

Any help will be greatly appreciated.--
tdoughty
------------------------------------------------------------------------
tdoughty's Profile: www.excelforum.com/member.php...oamp;userid=29616
View this thread: www.excelforum.com/showthread...hreadid=493180You could use a MATCH function to see if b1 is anywhere in Q1:Q150:
=if(isna(match(b1,$Q$1:$Q$150,false)),quot;quot;,quot;Yesquot;)quot;tdoughtyquot; wrote:

gt;
gt; I need help with an if statement. I have two seperate columns that I
gt; need to compare. I need to compare each value in one column to all the
gt; values in the other column to see if I have any that match. What should
gt; my formula look like?
gt; For instance I'm comparing column B with column Q and using the
gt; following formula but it is not working.
gt;
gt; =if(or(B1=$Q$1:$Q$150),quot;Yesquot;,quot;quot;)
gt;
gt; Any help will be greatly appreciated.
gt;
gt;
gt; --
gt; tdoughty
gt; ------------------------------------------------------------------------
gt; tdoughty's Profile: www.excelforum.com/member.php...oamp;userid=29616
gt; View this thread: www.excelforum.com/showthread...hreadid=493180
gt;
gt;


That worked. Thank you very much.--
tdoughty
------------------------------------------------------------------------
tdoughty's Profile: www.excelforum.com/member.php...oamp;userid=29616
View this thread: www.excelforum.com/showthread...hreadid=493180