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