AnsweredAssumed Answered

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

Question asked by dj1up on Jan 10, 2017
Latest reply on Jan 22, 2017 by 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.

Outcomes