INDEX MATCH instead of VLOOKUP
Posted 22nd January 2015
INDEX MATCH represents a much better way to search for data in Excel tables than VLOOKUP because this combination is much more versatile.
VLOOKUP in Excel with multiple criteria
Posted 3rd December 2014
An alternative to VLOOKUP in Excel that permits a search based on multiple criteria.