The cell I want to return is not numeric.
Or maybe an IF - that checks a whole column of data..& returns a cell when
it is true.

Yes, you need to be more specific with what you are looking up and what you
want it to return

=INDEX(A:A,MATCH("X",B:B,0))

if it finds X in column B it will return what's in A in the same row and if
not found it will return #N/A

You can also look at VLOOKUP



--


Regards,


Peo Sjoblom

"markholt" wrote in message
...
The cell I want to return is not numeric.
Or maybe an IF - that checks a whole column of data..& returns a cell when
it is true.