#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Hi
there seems to be something missing in your attachment. There are only a column with numbers and some headers.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
nested ifs or match / choose
Good morning.
I understand. I'm a newby at this. The columns are figures based upon choices. I need to be able to choose a criteria: Plan A, Plan B, Or Plan C. Under those headings I need to be able to choose Age: 18-65. And under each age I need to choose EE (employee only) or ES (Employee and spouse). Given those choices it brings back a figure, which are represented by the columns: AGE, EE-A,EE + SP-A and so on. I've tried to use vlookup for example using =IF(C9="A", and so on. I'm sure this is a simple formula, but I'm having problems figuring out how to express it and be able to allow for 3 different inputs/criteria. Any ideas? maybe an example where I might be able to figure it out? T |
#4
|
||||
|
||||
Perhaps it's a simple formula, but your table is completely empty
There is no relation between the plan, the age, the status, etc.. You talk about =IF(C9="a" but in your example c9 is empty? ( or am I missing something
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
vlookup on multiple criteria
Hi,
What I'm trying to do: I have an insurance table of values. If a person chooses Plan A, Or Plan B, Or Plan C they need to be able to choose another criteria. 2nd, they choose age, 18-65, Thirdly, they choose either EE or ES (Employee or Employee + Spouse). Given these choices the table needs to bring back a value for those criteria. Can I use Match/Choose or Vlookup with concatenation? I guess I could fool around with more and more, but I thought this is probably a simple problem for all the guru's out there. I'm still learning Excel and how to use it. I rarely use it in this form, mostly the basics. Any ideas on this one? |
#6
|
|||
|
|||
Vlookup or Index/match
I've tried a few options on this one but can't find the right formula's to give me what I need.
I've included the spreadsheet. I want to be able to put in the Plan: A,B, OR C, then put in the AGE: 18-25, then put it the EE or ES. From this I need to lookup a figure and bring it back. I'm doing this kind of spreadsheet for 3 states with different figures, but the same plans,age,EE/ES setup. Any ideas? see screenshot below Plan APlan BPlan CAGEEEESEEESEEESEE(Employee Only)18101215253565EE + Spouse19161518314075LTCTable12022182137458521282124435095223424274955105234027305560115244630336165125CHOOSE:INPUT:Plan type:Aj16255233366770135Age25j17EE or ESESj18265836397375145Price/Month#N/A27643942798015528704245858516529764548919017530824851979518531885154103100195329454571091052053310057601151102153410660631211152253511263661271202353611866691331252453712469721391302553813072751451352653913675781511402754014278811571452854114881841631502954215484871691553054316087901751603154416690931811653254517293961871703354617896991931753454718499102199180355481901021052051853654919610510821119037550202108111217195385512081111142232003955221411411722920540553220117120235210415542261201232412154255523212312624722043556238126129253225445572441291322592304555825013213526523546559256135138271240475602621381412772454856126814114428325049562274144147289255505632801471502952605156428615015330126552565292153156307270535 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Nested Countif Function | bdavidson22 | Excel | 0 | 12-19-2014 12:36 PM |
Nested Vlookup Help | asluder2000 | Excel | 2 | 11-14-2014 11:00 PM |
How to setup Nested If statement | bigukfan | Mail Merge | 4 | 04-30-2014 05:19 AM |
Nested vlookup with varable tables! | Dave Jones | Excel | 0 | 08-30-2012 09:15 AM |
Nested IFs | JimS378 | Excel | 7 | 05-03-2011 08:20 PM |