Excel Search Function??

[C Fillmore]

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

 

[Jason Morin]

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

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

 

[Vasant Nanavati]

=IF(ISNA(VLOOKUP(A1,E1:E1000,1,FALSE)),FALSE,TRUE)

--

Vasant

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