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

--
dilettante

You are a little off on your code, try this
=HLOOKUP(MAX(A2:G2),A2:G3,2,FALSE)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"dilettante" wrote:

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

--
dilettante

It works, thank you!
Best regards
--
dilettante


"John Bundy" wrote:

You are a little off on your code, try this
=HLOOKUP(MAX(A2:G2),A2:G3,2,FALSE)
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"dilettante" wrote:

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

--
dilettante