Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

INDEX MATCH instead of VLOOKUP

Posted 22nd January 2015

1 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

Posted 3rd December 2014

No 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

Posted 4th September 2014

2 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...