XLOOKUP with regex match
To use a regex pattern in an XLOOKUP formula, you can enable "regex match" as the match mode and then provide a regex pattern in the lookup value. In the worksheet shown, the formula in F5 looks like this: …Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
LET Function
The Excel LET function lets you define named variables in a formula. There are two primary reasons you might want to do this: (1) to improve performance by eliminating redundant calculations and (2) to make more complex formulas easier to read and write.Read more
Recent Articles
Combinations and permutations in Excel
Combinations and permutations are two basic ways to count possibilities, used in probability, statistics, games, passwords, and lotteries. This article explains the difference between them, when order and repetition matter, and the Excel functions you can use to calculate each case: FACT, PERMUT, …Read more
Topics By Category
User Testimonials
ExcelJet is the best Excel website I've read - and I've read many, I tell you. If you know what function to use but not how to use it, look at ExcelJet, the articles are super clear.
Alexandre
I am very very grateful to this particular website as I have got an exposure to a large number of examples with the latest formulae, and practical examples have been beautifully illustrated & explained in simplified ways.
Shubhrojyoti
Your Website is excellent. It is helpful with substance and clarity and it has an attractive look. It gives me the feeling that the creators of this website live on the same Planet as I do. I don't always get the feeling when I use Microsoft help.
Andre
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.
