Featured Formulas

Lookup

XLOOKUP wildcard contains substring

To create a "contains substring" type lookup formula, you can use the XLOOKUP function with wildcards. In the example shown, the formula in F5 is: XLOOKUP("*"&G4&"*",data[Title],data,,2) Where G4 contains a partial string to look for and data is an …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Math

SUMPRODUCT Function

The Excel SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products. This sounds boring, but SUMPRODUCT is an incredibly versatile function that can be used to count and sum like COUNTIFS or SUMIFS, but with more flexibility. Other functions can easily be used inside …Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Your solution to the problem of extracting all the values in a lookup is the most elegant I have ever seen. It is clean, easy to remember, and easy to understand. Y'all are my favorite people now. Thank you so much.
James
I just wanted to say thank you for all the help you've been to me through your website. I absolutely love the way you breakdown formulas...I can honestly say, there have been projects that would have been significantly less successful if it wasn't for the assistance you provided.
Marc
Just wanted to thank you for the amazing content. I've been using Excel for quite some time now, and I've scoured dozens of sources that gave useless advice you'd have to squint to properly see and understand. I've hit two of your pages in two google searches in the past five minutes and am kinda cross with myself for not finding it sooner. I'm here to stay, guys. Thank you from the bottom of my heart.
Said
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