Excel Table. Lookup where range and multiple criteria

Hi I previously posted a question seeking a formula to lookup a value from a table which uses ranges (ie min and max max values).  Ryan provided a good solution using Index & Match functions.
But I now need to cover multi-criteria.
I'm not familiar with macros so would prefer to avoid.
Could someone provide a formula which I can readily update to suit actual number/type of criteria (eg 2 criteria, some exact match, and some that involves fitting in a range).
I have attached a file showing current table for which I need lookup type formula
Thanks
gh_userAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
0
 
Saqib Husain, SyedEngineerCommented:
You would have to upload a sample excel file. Make sure that the sample represents the actual as much as possible so that a workable solution could be proposed.
0
 
gh_userAuthor Commented:
Sorry, did I forget to upload sample.  Here it is.
Example-table.xlsx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Saqib Husain, SyedEngineerCommented:
Try this array formula (Do you know how to enter array formulas?)

=INDEX($F$3:$F$17,MATCH(1,(B22>$A$3:$A$17)*(B22<$B$3:$B$17)*(B23>$C$3:$C$17)*(B23<$D$3:$D$17)*(B24=$E$3:$E$17),0))
0
 
gh_userAuthor Commented:
Thanks Saqib.  Are you able to demonstrate in the file I provided using the example table!
0
 
gh_userAuthor Commented:
Thanks Saqib for being prompt and providing demonstration.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.