Index and Match in Excel is = to "What?" in FM10

Discussion created by nico357 on Jun 20, 2017
Latest reply on Jun 21, 2017 by philmodjunk



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