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

Math

SUMPRODUCT Function

The SUMPRODUCT function multiplies arrays together and returns the sum of products. If only one array is supplied, SUMPRODUCT will simply sum the items in the array. Up to 30 ranges or arrays can be supplied. When you first encounter...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Fantastic learning email! Thanks for this. I appreciate it as I hadn't ever encountered a formula like this. Keep it up.
Don
Do You Have a T-Shirt? I Love ExcelJet Desperately. Seriously, you guys have saved my butt a BILLION TIMES. I've copied a bunch of your formulas into my software consulting training materials. I often find myself up at 2 AM with a daunting project in front of me, only for one of your formulas to cut my project time by 90%.
Peter
You made working with Excel more fun and really easier.
Yen
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