![]() |
|
#1
|
|||
|
|||
![]()
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 | 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 |
![]() |
JimS378 | Excel | 7 | 05-03-2011 08:20 PM |