Hi everybody , and a good day !

A B C D E
row 1 1 2 3 4 5
row 2 2 4 7 1 88
row 3
row 4

I need a function or formula , which if in
row 2 , range A2:E2 , the value is 1 (for
eg.) , to return me the value of above cell
of the value I look for ;
In this case , to return value 4 ;
If I look for value 88 in row 2 , range
A2:E2 , to return 5 .
Thank you very much for your knowledge
share .