INDEX and MATCH as alternative VLOOKUP in Excel

VLOOKUP is a very useful and powerful Excel formula. It has however, its limitations: for example, the searched word must be obligatory in the first column of the search matrix. This article provides an alternative to VLOOKUP.

The alternative would be to use a combination of the formulas INDEX and MATCH instead. There are plenty of tutorials on the web about this couple of formulae.

You might also be interested in…

External References

Leave a Reply

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