Forum Discussion

Zaid999's avatar
Zaid999
Copper Contributor
Aug 17, 2023

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...
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 17, 2023

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.

  • Zaid999's avatar
    Zaid999
    Copper Contributor
    Aug 17, 2023
    Many thanks for the response and also for the various options (very thoughtful)
    I use Excel 365

Resources