Featured Formulas

Lookup

Find closest match

To find the closest match in numeric data, you can use the XLOOKUP function or an INDEX and MATCH formula. In the example shown, the formula in F5 is: =XLOOKUP(0,ABS(C5:C16-E5),B5:B16,,1) The result is "Tokyo" because the cost of $1195 is closest to …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

EOMONTH Function

The Excel EOMONTH function returns the last day of the month, n months in the past or future. You can use EOMONTH to calculate expiration dates, due dates, and other dates that need to land on the last day of a month. Use a positive value for months to move forward in time, and a negative number to …Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Since I started working 6 months ago, I've been using Excel extensively. And I cannot put in words how grateful I am. You've been helping me alot with your blog posts! Thanks!
Fabricio
I love your articles. They're the cleanest, most efficient place to get Excel knowledge.
Sebastian
I now work for a homeless charity and wanted to be able to see how many rooms we have free in the hostel at any given time without manually counting them each time. I knew there would be a way to do it but didn't know how! I spent only a couple of minutes on your site and found the answer: I needed "countif" instead of "count" which I'd been trying and it worked straight away once I got my brackets in the right place!!
Annette
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