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