Featured Formulas

Lookup

XLOOKUP binary search

In this example, the goal is to look up amounts for 1000 invoice numbers in a table that contains 1 million invoices. The catch is that not all of the 1000 invoice numbers exist in the source data. In fact, most of the invoice numbers do not appear in column B. This means we need...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Logical

IFS Function

The IFs function evaluates multiple expressions and returns a result that corresponds to the first TRUE result. You can use the IFS function when you want a self-contained formula to test multiple conditions at the same time without nesting ...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

This is my go-to website for excel you have helped me out many times. Thanks so much to your clarity and transparency and integrity in all you do.
Jennifer
Just wanted to give a HUGE thank you for all of your content. I was NOT proficient at Excel, even though my resume clearly says differently ;), until I found this website. Now, I've become the "Excel Guy" at my company and I owe 90%-ish to ExcelJet. I have yet to find another website that gives clear, concise, and in-depth explanations like you do. KEEP UP THE GREAT WORK!
James
I'm 2/3 done in the Dynamic Arrays course, and I have some feedback to share with you. It's absolutely awesome in a nutshell.
JP
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