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 | 3 | 4 |
---|---|---|---|---|

| .75 | |||

B | 1.0 | .75 | ||

C | 1.25 | 1.5 | .75 | |

D | 3.5 | 2.0 | 2.0 | 2.0 |

Any help wold be great. Thank you.

Not the Excel forum. did you wonder how to do this in FileMaker?

beverly