formula to compare a values and return

[DSnuh]

I'm looking for a formula to compare text in one specific cell with information in a range of cells within a column. If the text in the original cell matches and of the information in the column of cells, then display a "found"... if not display "not found".

EXAMPLE
original cell = 25
column of cells are random numbers
if it finds 25 in the column, then return "found"
if it does not find 25 in the column, then return "not found"

 

[XLPadawan]

If the value is entered in B1, one formula would be:

=IF(ISERROR(SUBSTITUTE(ADDRESS(MATCH(B1,A:A,0),1),"$","")),"not found",B1&" was found in cell "&(SUBSTITUTE(ADDRESS(MATCH(B1,A:A,0),1),"$","")))

Note that this formula will give the cell reference for the first occurrence of the entered value.

 

[jerome drean]

i dont see the need for substitute() though