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.
- “Index Match: The Better Alternative to Vlookup” by @RealSecretJake at PPC Hero