h.lookup trouble

  • Thread starter Thread starter Øyvind Granberg
  • Start date Start date
Ø

Øyvind Granberg

Hi...
I have this matrix containing five columns and 13 rows.
I want to find the column with highest number in a row, and get the value in
row 13 in that column.
See: http://www.granberg.name/images/poisson.png
The formula I use did exactly that in the first row, but after copying
downwards the formula returned the number in the last column only.
Here is the formula:
=FINN.KOLONNE(STØRST(AI11:AM11);$AI$10:$AM$22;13)
Translated:
=HLOOKUP(MAX(AI11:AM11);$AI$10:$AM$22;13)

Why does my formula work fine in the first row and not in the next one?

--

Kind regards
Øyvind Granberg

(e-mail address removed)
www.tresfjording.com
 
try this one

=HLOOKUP(MAX(AI10:AM10),AI10:AM$22,ROWS(AI10:AM$22)) and copy it down.
 
Thank you M.M :-)
The ROWS-function did it, but I had to add a FALSE statement at the end of
your formula.

Works fine

Thank you again!!

--

Kind regards
Øyvind Granberg

(e-mail address removed)
www.tresfjording.com
 
Back
Top