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?
|