VLOOKUP - reference sheet, based on two criteria
Is it possible to use a VLOOKUP formula to pull data from a reference sheet based on conditions in the original sheet?
I have two things I am trying to have automatically calculated in my original sheet: # of Team Members (based on the Total Enrollment and Classification columns on this sheet that tell me what reference sheet range to use); and Engagement Review Fee (based on the same two criteria on the original sheet that indicate what reference sheet range to use). Here's a snip of my original sheet, with the data for Total Enrollment and Classification (circled in green).
The red boxed cells are the two cells I am trying to calculate an automatic formula to pull values from my reference sheet with the following information:
The classification of Early Learning or School on the original sheet would point to the School institution type on the reference sheet, to pull the correct # Team Members based on enrollment and the correct review fee based on enrollment. I also have other classifications on the original sheet that would need to point to other ranges on the reference sheet.
Thanks for any help anyone can provide!
Help Article Resources
Check out the Formula Handbook template!