index-match functions problem; spreadsheet attached

[George Dimitrov <gdparlichev gmail com>]

Hi,

I converted a LibreOffice Calc spreadsheet to Gnumeric, but the index-match combination of functions didn't work. Can somebody tell me how to solve this. The problem is in columns MLRH and MLRA. For example, in row 3, the goal of the function under MLRH is to find the largest value from rows A3:AW3 and to return the corresponding value from rows A1:AW1. Similarly, the goal of the function under MLRA is to find the largest value from rows A3:AW3, but to return the corresponding value from rows A2:AW2 instead.
I have attached a spreadsheet for your review (file: E0.gnumeric).

Best regards,

George

Attachment: E0.gnumeric
Description: application/gnumeric