Featured Formulas

Lookup

VLOOKUP with multiple criteria advanced

To apply multiple criteria with the VLOOKUP function you can use Boolean logic and the CHOOSE function. In the example shown, the formula in H8 is: =VLOOKUP(1,CHOOSE({1,2},(H5=data[Item])*(H6=data[Size])*(H7=data[Color]),data[Price]),2,0) where …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

VSTACK Function

The Excel VSTACK function combines arrays vertically into a single array. Each subsequent array is appended to the bottom of the previous array.Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I just want you to know that ExcelJet has quite honestly changed my life...I now have my own business as a bookkeeper. Bookkeeping requires Excel on a DAILY basis to manipulate data & get it in and out of QuickBooks. I use conditional formatting, INDEXMATCH, VLOOKUP, IFS, everything I have learned from ExcelJet. The 2-3 minute courses are a dream ..... I could open up 5 and watch them and come back later. Plus you are all super organized & clear in how you teach Excel. Watching videos on YouTube piecemeal from many different instructors never worked for me. ExcelJet was the real deal!!
Ainsley
I just wanted to say thank you for the useful tutorials...This info is really useful for me at the moment because I'm just starting my first job while I'm not yet graduated from college.
Andrea
Yes, that is exactly what I mean, thank you! You guys are great - who would’ve thought that Excel could be fun :)
Alex
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