Featured Formulas

Lookup

Left lookup with INDEX and MATCH

In this example, the goal is to lookup data to the left of an ID that appears as the last column in the table. In other words, we need to locate a match in column E, then retrieve a value from a column to the left. This is one of those problems that is...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

VSTACK Function

The Excel VSTACK function combines arrays vertically into a single array. Each subsequent array is appended to the bottom of the previous array. The result from VSTACK is a single array that spills onto the worksheet into multiple cells....Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Thanks a lot, this is perfectly working and saving me hours.
Sven
You are an angel. I have been forever frustrated when searching for help and finding no one gets what you get...teach the basic principle first!! Thank you, Thank you!
Christine
I look for your site whenever I'm googling excel functions because of how quickly and easily it has answered my questions. I am an experienced programmer and I really like how "to the point" your articles are, with examples that really show what I'm trying to do.
Alonzo
More Testimonials

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages