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, 9 views)

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

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

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

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?

Attached Files

Book1.xlsx (12.7 KB, 6 views)

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, 8 views)