Featured Formulas

Lookup

Look up entire column

In this example, the goal is to look up and retrieve an entire column of values in a set of data. For example, when a value like "Q3" is entered into cell H4, all values in the range E5:E16 should be returned. For convenience and readability, quarter (C4:F4) and ...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

EOMONTH Function

The EOMONTH function returns the last day of the month, a given number of months in the past or future. You can use EOMONTH to calculate expiration dates, due dates, and other dates that must land on the last day of a month. EOMONTH returns a serial...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

KUDOS on such a wonderful site. THANK YOU.
David
I just subscribed recently, and I love your email tips and the good info on your web site.
Walt
This site has proven to me time and time again, that this is THE BEST excel resource. I am able to learn new excel functions and formulas as needed in a simple and straight-forward way. Where most excel resources force you to sift through a large amount of information to find the specific solution you are looking for, exceljet is extremely specific and straight to the point. Your site has made me so much more efficient at my job, and has carried over to my personal use of excel as well. Thank you!!
Katie
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