14 Replies Latest reply on Jun 21, 2017 7:46 AM by philmodjunk

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

    nico357

      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