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
Any help wold be great. Thank you.