Jump to content
  • 0

An easier way to do a complex lookup table?


ivorykeys87
 Share

Question

I am trying to create a simple solution for finding a commission percentage based on the contract levels of a given agent. I could do a lookup table per insurance carrier, but here's how that would potentially look.

Carrier=Aetna    Products=6      Contract Levels= 10         Plan Types = 20      All offered in 50 states with varying commission amounts per state. This one lookup table would have over 60,000 rows! Now multiply that by all the various insurance carriers and you see the conundrum. There has to be an easier way to look up these values in a table than this. 

For those familiar with Excel, I originally did it in there using an INDEX(MATCH()MATCH()) formula on a pivot table. This greatly reduced the amount of cells needed. But there doesn't seem to be a way to replicate this method on Caspio. 

 

Any idea would be greatly appreciated. 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...