Find value in row, return the value in same column diff row

[SamMaynard]

I need a formula or named constant that can look for a particular value in a row (such as "hi") and then return the value of the cell in row 1 directly above.

In plain english; look for the text "hi" in a row, then return the value of the cell in that same column but in row 1.

Any help is much appreciated.

Thanks,

 

[jindon]

Re: Find value in row, return the value in same column diff

Hi,

What if there are more than 2 "hi" s in the specific column?

rgds,
jindon