Hi,

I'm new to FM and use a rather old version (FM Pro 10 Advanced). I have to convert an Excel table that uses this formula: "INDEX(A1:A5,MATCH(MAX(B1:B5),B1:B5,0)). This formula returns the max value from the column B1:B5, matches the row where this max value is with the column A1:A5 and returns the value from the column A1:A5, which is on the same row.

I have googled this issue but could not find any hint. Could someone help me with this

thank you very much in advance

Nicolas

You need different thinking in database, from spreadsheet.

There is no "range of row" in database. Does your Excel table have only total 5 rows?