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.
Open and close Excel workbooks in the background
Posted 4th September 2014
Use a Visual Basic for Applications (VBA) script to open secondary Excel workbooks as data sources when opening a VLOOKUP-dependent workbook.