Hlookup for row 3 and 4

[Guest]

I am getting crazy trying the following:

row 1 cell A1 =hlookup(A2:F3;max(A2:F2);1) (closed with shift ctr enter)
row 2 cells 23 25 43 10 0 12 25 (as results of sum(A4:A50 - B4:B50 -
etc.)
row 3 cells aa db ac ya fg ig rs (text)

I get always as result "rs"
What am I doing wrong?
Thank you feor help

 

[Guest]

You are a little off on your code, try this
=HLOOKUP(MAX(A2:G2),A2:G3,2,FALSE)

 

[Guest]

It works, thank you!
Best regards
--
dilettante

You are a little off on your code, try this
=HLOOKUP(MAX(A2:G2),A2:G3,2,FALSE)