Using index/match/match to locate a value in a grid

You may be familiar with index/match but there’s another variation that I like to call index/match/match (like New York – so good they named it twice). This is about how to use a Match function (which I describe as being a bit like salt – you generally don’t eat it on its own – it’s usually with something else 🙂 with the Index function. You can download the file here

You can view the video here

 

 

If you found this blog useful, why not give it a share?

Facebook
Twitter
LinkedIn
Pinterest
Reddit
Email
Print

Leave a Reply

Your email address will not be published. Required fields are marked *

five × 1 =