Featured Formulas

Lookup

XLOOKUP wildcard contains substring

The goal is to look up the Title, Author, and Year in the list of books as shown using a formula based on a partial match and a wildcard. The text string to search for is entered in cell G4. All data is in an Excel Table named data in the range B5:D16. This problem can be easily solved with the...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

I just wanted to add my comment to the many many others who appreciate the clear concise and informative information here. I find these days when I'm looking for help on excel I start by searching exceljet. Great stuff I'm a fan.
Barnaby
Thanks so much for Exceljet. It is the most helpful website I know for learning and getting around complex software.
Rich
Not far from 40 years (beg. with Visicalc in 82) of intensive spreadsheet use (+develop solutions +teach) and fully amazed with so many great ideas of formulas found in your examples.
jhbf
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