Thread: [Solved] using if and nested vlookup
View Single Post
 
Old 06-10-2015, 11:45 AM
wentworth16238 wentworth16238 is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Jun 2015
Posts: 4
wentworth16238 is on a distinguished road
Default using if and nested vlookup
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
File Type: xlsx Book1.xlsx (8.4 KB, 11 views)
Reply With Quote