Exceljet

Featured Formulas

XLOOKUP with Boolean OR logic

In this example, the goal is to use XLOOKUP to find the first "red" or "pink" record in the data as shown. All data is in an Excel Table named data in the range B5:E14. This means the formulas below use structured...Read more

Count

Count cells equal to this or that

Lookup

Left lookup with INDEX and MATCH

More Formulas

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.

Date and time

EOMONTH Function

Lookup and reference

VLOOKUP Function

More Functions

Recent Articles

Formulas

XLOOKUP vs INDEX and MATCH

For many years, INDEX and MATCH have been the go-to solution for difficult lookup problems in Excel. While more complicated to configure, the two-function combination of INDEX + MATCH is flexible and powerful. But now that...Read more

Formulas

What is an array formula?

Formulas

Shortcuts

Functions

User Testimonials

Your SUBSTITUTE formula for cleaning up phone numbers works perfectly, and saves a TON of time - thank you so much!

Janet

As a researcher I work a lot with Excel and often I can find good solutions on your website. Thank you & keep up the good work!

Paul

I have been saved countless times by EXCELJET. I know you guys always have the answer to my tangled excel questions, and it's always quick, easy to understand, and super easy to implement into my workbooks!

Sarai

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

Learn Excel with clear examples and bite-sized videos.

Featured Formulas

XLOOKUP with Boolean OR logic

Count cells equal to this or that

Left lookup with INDEX and MATCH

Featured Videos

FILTER function with two criteria

How to use VLOOKUP for approximate matches

How to fill in missing data with a simple formula

Excel shortcuts on a Mac

Featured Functions

VSTACK Function

EOMONTH Function

VLOOKUP Function

Recent Articles

XLOOKUP vs INDEX and MATCH

XLOOKUP vs VLOOKUP

Why SUMPRODUCT?

How to concatenate in Excel

What is an array formula?

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Get Training

We offer free resources and paid training.

Learn Excel with clear examples and bite-sized videos.

Featured Formulas

Featured Videos

Featured Functions

Recent Articles

Topics By Category

User Testimonials

Newsletter Sign-up

Conquer Excel

Get Training

We offer free resources and paid training.