Reference Cell if Found in a IF function
 

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)

Reference Cell if Found in a IF function
 

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.

"A Stevens" wrote:

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)

Reference Cell if Found in a IF function
 

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)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"A Stevens" wrote in message
...
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.

"A Stevens" wrote:

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)