Forum Discussion
Index Match Multiple Criteria
I am a newbie and I understand the general index match lookups. However I am struggling with a more complicated set of information that needs an index match but with applicability criteria. Examp...
Zaid999 You don't mention which Excel version you are using, so I came up with a few solutions. See if any of these suits you. I'm quite sure that there are other options to achieve this, but three will do for me right now.
Edit: Hadn't seen HansVogelaar 's post before I posted mine. Now you have more to choose from.
Many thanks for the response and also for the various options (very thoughtful)
I use Excel 365
I use Excel 365