How to Use the Simplest INDEX(MATCH) Exact Lookup
You say, “I could never use INDEX(MATCH): It looks too complicated!” Well, here is the very simplest example, which anyone can master (or mistress). Here we are only looking for an exact match. For simplicity, we will use one-column arrays only. Once you are happy with this, if you want two-dimensional examples, read this following…