SAMPLE.xlsx
I am trying to get the rate for members that meet four criteria in column E from the rate table tab.
The current columns and criteria are:
A B C D
Cnty *** Age Group
The problem I'm having is using an Index Match formula I can't get anything that works for the age minimum and age maximum in the rate table; for instance Males between 6 and 18, and how do I get it to index the Group columns in the rate table. I have attached a sample file that illustrates it better.
Bookmarks