match | Adam Dimech's Coding Blog

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.

Posted 3rd December 2014

No comments

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