Search a column for a value and return T or F

C

CraigMacE

I am trying to make a list that searches another column for a value and then
returns True if the value is found. What I have only recognizes the value if
it is found in the same row.

My formula reads =IF(A2:A1000=AD2,"True","False") Column AD contains a list
a values that are searched for.
 
R

Ron Coderre

Try this:

=IF(COUNT(MATCH(AD2,A2:A1000,0)),"True","False")

or this:
=IF(COUNTIF(A2:A1000,AD2),"True","False")

or maybe this:
=COUNTIF(A2:A1000,AD2)>0

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 

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

Field or formula to return last value in a column? 7
Search for value on another sheet, return Y/N 3
Search one column and return value from next column 2
Which Function to Use? Search an Array, Return a Row Value 1
Excel VBA 1
Vlookup with If condition 1
Scrabble Value calculation for Welsh words 0
lookup and return column number 2

Top