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

Attached Files

Book1.xlsx (14.0 KB, 10 views)