Hi,
I have an insurance table which I've just received. I need to look up a particular figure based upon Either Plan A,B,or C. Then I need to Choose the age,ie age 25. From there I need to choose either EE (employee only) or ES (Employee + spouse). From these criteria I get a specific feedback or figure.

I've attached the spreadsheet Book 1. as an example. What I want to do is to be able to use the three factors: Plan Type, Age, and EE/ES to lookup the figure.

I'm a veritable newby at this have tried a few combinations that I've found on the internet, but with little success.


Can anyone help with this.

Attached Files

Book1.xlsx (8.4 KB, 11 views)