Skip to content

INDEX MATCH instead of VLOOKUP

G22nd January 2015 

C1 comment

INDEX MATCH represents a much better way to search for data in Excel tables than VLOOKUP because this combination is much more versatile.

Read the full story

VLOOKUP in Excel with multiple criteria

G3rd December 2014 

CNo comments

An alternative to VLOOKUP in Excel that permits a search based on multiple criteria.

Read the full story

Open and close Excel workbooks in the background

G4th September 2014 

C2 comments

Use a Visual Basic for Applications (VBA) script to open secondary Excel workbooks as data sources when opening a VLOOKUP-dependent workbook.

Read the full story