Reference Cell if Found in a IF function

A

A Stevens

I'm trying to setup an IF function so that it searches for a value, then if
Value is found (TRUE), to offset from the cell within which it was found.
Ex:
With the formula written into Sheet 2, B, I want it to search column A of
Sheet 1 for a 22, then if found offset from where it was found up one cell
and report the station name.

Sheet 1 Sheet 2
A A B
Station Name 22 Station Name(variable)
22 (variable)
 
A

A Stevens

Formatting came out funny in my example. Hope the text is clear enough...
if more is needed let me know and I'll try to explain further.
 
R

Ragdyer

With your datalist on Sheet1 in Column A,

Try this on Sheet2, in B1, with your value in A1:

=INDEX(Sheet1!A1:A100,MATCH(A1,Sheet1!A1:A100,0)-1)
 
Top