Excel Search Function??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data in five columns (A,B,C,D,E are the headers) and an unlimited number of rows (can vary from one instance to another) and what I would like to do is with a function in the cell F1 use the value from A1 and search all values in column E, and return a "True" statement if the exact value from A1 is found and if no exact value is found return a "False". Any ideas
 
=COUNTIF(E:E,A1)>0

HTH
Jason
Atlanta, GA
-----Original Message-----
I have data in five columns (A,B,C,D,E are the headers)
Click to expand...
and an unlimited number of rows (can vary from one
instance to another) and what I would like to do is with
a function in the cell F1 use the value from A1 and
search all values in column E, and return a "True"
statement if the exact value from A1 is found and if no
exact value is found return a "False". Any ideas
 
=IF(ISNA(VLOOKUP(A1,E1:E1000,1,FALSE)),FALSE,TRUE)

--

Vasant

C Fillmore said:
I have data in five columns (A,B,C,D,E are the headers) and an unlimited
Click to expand...
number of rows (can vary from one instance to another) and what I would like
to do is with a function in the cell F1 use the value from A1 and search all
values in column E, and return a "True" statement if the exact value from A1
is found and if no exact value is found return a "False". Any ideas
 
Back
Top