8 Replies Latest reply on Jan 22, 2017 10:57 PM by dj1up

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

    dj1up

      HI guys so i have a table in excel and im using a Index(Match) formulia to get a value.  Ive tryed using DDE but its seeming to be more truble then its worth. 

       

      What can I do with filemaker so i dont have to create lots of tables to get the same result?  heres what im dealing with:

       

      Two Cal Fields:

      SkierCode: (A,B,C,D ect.....)

      ColNumber: (1, 2, 3, ect....)

       

      So SkierCode = C, ColNumber = 2 Answer is = 1.5

       

      1
      2
      34

      A

      .75
      B1.0.75
      C1.251.5.75
      D3.52.02.02.0

       

       

      Any help wold be great. Thank you.