Use Excel VBA to Test Report Calculation Times
I once exchanged email with an experienced Excel jockey who insisted that VLOOKUP was Excel’s fastest lookup method. It was even faster, he said,...
How to Use INDEX-MATCH, Part 3: Six Lookups That VLOOKUP Can’t Do
In this three-part series, I'm showing you how to use INDEX-MATCH. In Part 1, I showed you how to use the INDEX function. In Part...
Excel’s VLOOKUP vs INDEX-MATCH Functions
Excel offers two primary lookup methods: VLOOKUP and INDEX-MATCH. Although the two methods are similar, INDEX-MATCH is more powerful.
I suspect, however, that VLOOKUP is better-known and more...
How to Use INDEX-MATCH, Part 2: The MATCH Function
In this three-part series, I'm showing you how to use INDEX-MATCH. In Part 1, I showed you how to use the INDEX function. Here,...
How to Use INDEX-MATCH, Part 1: The INDEX Function
Which is best, VLOOKUP or INDEX-MATCH?
You might be surprised at the question, because the answer never has been in doubt. INDEX-MATCH can do anything...
Use Excel’s INDEX-MATCH or VLOOKUP Functions to Populate Invoices and POs
A visitor asked how to set up a simple invoicing system in Excel.
This is a common problem in many small businesses, divisions, and sales...
Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in Excel
(Download the workbook.)
Excel’s VLOOKUP function is more popular than the INDEX-MATCH function combination, probably because when Excel users need to look up data then a "lookup" function...
How to Perform Multiple Table Searches Using the SEARCH & SUMPRODUCT Functions in Excel
SUMPRODUCT is one of Excel's most-powerful worksheet functions. Here, for example, you can use it in one formula to search text in one cell...
Latest Articles
Getting Radical with Excel
It's time to think about Excel in a radical new way—when we use it to work with business or economic data.
It's time, in fact,...
How Fast Is Too Fast?
(Originally published in Inc Magazine.)
What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
How to Smooth Data by Using the TREND Function
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Advertisement