I have a table that i want to have users be able to put in the X and Y axsis and have creator output the intersect data. Basically i have inputed a chart that usually you can lookup the years your have been there and current level with the company and the intersect point would be their pay. EXAMPLE BELOW
TIME
Level 1 2 3
1 20 70 120
2 30 80 130
3 40 90 40
4 50 100 150
So lets say a user inputted that they Level was 3 and time was 2 the output would be 90. If they said their level was 4 and time was 3 it would out put 150.
I already have the table in ZC and created the form that the user would see to input their data, i just dont know how to make ZC cross reference the table like that.
THANKS IN ADVANCE FOR ANY HELP YOU CAN GIVE!!