title: Multiple Criteria Match (and Value between Range)
body: <p>I need to be able to return the class ??? based on a match based on course, category, gender, and age which would fall between the min and max acceptable.  I am thinking that this would be some form of index(match(......however I cannot figure out how to fit it with the range and ensuring the the other 3 requirements match.</p>
  
  <p>Below is a link to a sample of what I am looking for.  Need ??? solution in M2</p>
  
  <p><a href="https://www.dropbox.com/s/t57vjywj8ps414m/Test%20Matching%20Based%20on%20Range.xlsx" rel="nofollow">https://www.dropbox.com/s/t57vjywj8ps414m/Test%20Matching%20Based%20on%20Range.xlsx</a></p>