Best Microsoft Excel Bloggers

Wednesday, May 17, 2017

VLOOKUP versus INDEX MATCH! Which is Better?

VLOOKUP versus INDEX MATCH! Which is Better?

vlookup and index match

Chris Chau of asked twenty-seven (27) Excel MVPs and community experts their preference  on the ongoing controversy of VLOOKUP vs. INDEX MATCH. it is great reference material and some suggest choices they think are better than those two functions!

Click on the link to read the blog.

Check out the results. According to Chris, there was no clear winner so which do you use and prefer?   It really is liking asking who is better -Superman, or Batman!

If you want more information after reading Chris' blog, check out my course Become a Lookup Expert.  

It provides a comprehensive examination of the Lookup and Reference category in Excel. It covers the LOOKUP and VLOOKUP functions.
With VLOOKUP, you will learn how to: use Wildcards; search through multiple sheets for a match; and what to do if a match is not in the first column of your table. The course also explores HLOOKUP. It explains the advantages and disadvantages of INDEX MATCH versus VLOOKUP. It reviews the OFFSET function, which allows you to write calculations that automatically update as new data is added. With the INDIRECT function, you will learn how to find data on other worksheets sheets.  Finally, HYPERLINK is briefly discussed.

No comments:

Post a Comment

Ms. Excel- Resident Excel Geek