Featured Formulas

INDEX and MATCH approximate match with multiple criteria

In this example, the goal is to look up the correct shipping cost for an item based on the shipping service selected and the item's weight. At the core, this is an approximate match lookup based on weight. The challenge is that we also need to filter by service. This means we must apply criteria...Read more

Featured Functions

TEXTAFTER Function

The Excel TEXTAFTER function extracts text that occurs after a given delimiter. When multiple delimiters appear in the text, TEXTAFTER can return text that occurs after the nth instance of the delimiter. TEXTAFTER can also extract text after a specific delimiter when counting...Read more

Recent Articles

I have been an avid follower of your AWESOME site (if I may say so), for many years. What you don't know is how much you and your site have helped me over these years. I thank you for your PERFECT site and your dedication to keeping it updated over this time. Well done.
Adam
I've been using your site for years to understand Excel functions better and apply the ones I need to solve problems I have. I've just found another article that was clearly labeled and got me the solution for my problem straightaway (https://exceljet.net/formulas/index-and-match-on-multiple-columns), using functions way beyond my level of knowledge, and so I wanted to reach out to say thanks for such clear and useful resources that your site and your newsletter are.
Patrick
This site rocks. Great work on maintaining it. it contains very valuable info in a synthesized way. I often refer colleagues to it when they struggle with an excel problem. Keep it up guys, and thank you for slowly turning me into an excel wiz.
Ivu

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