Excel made easy
Database of Excel tips and tutorials.
Latest Excel Tips and Tutorials
10 useful XLOOKUP Equations
Explore 10 useful XLOOKUP equations in Excel. These can easily be adapted to fit your own needs. This equation looks up the value in cell A1 in the […]
Continue readingCreate a Social Security Calculator in Excel
Here is a step-by-step guide to create a Social Security Calculator in Excel: Note: The formula assumes that you were born in 1960 or later, and that you […]
Continue readingXMATCH Function in Excel
The XMATCH function in Excel is used to perform a lookup and return the position of a value in a range. XMATCH supports both exact match and approximate […]
Continue readingUse XLOOKUP with multiple sheets
To use XLOOKUP with multiple sheets, you can specify the sheet name followed by an exclamation point (!) in front of the cell range. For example, if you […]
Continue readingAdvanced Xlookup and VBA Equations
Advanced Xlookup and VBA equations in Excel can include complex conditional statements, loops, and custom functions to perform more complex calculations and manipulations. Here are a few examples: […]
Continue readingLearn about XLOOKUP
Learn how to use the XLOOKUP function in Excel. See for yourself why this new function makes Excel that much easier.
- XLOOKUP with Multiple Criteria
Perform an XLOOKUP with multiple Criteria using concatenate features in Excel - XLOOKUP Horizontal Lookup
With XLOOKUP, you no longer have to use the very limited HLOOKUP function. - XLOOKUP Function in Excel
XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! - Fix XLOOKUP #SPILL Error
Learn to easily fix an XLOOKUP #SPILL Error in Excel.
camera tool ceiling criteria date DAYS dynamic effect end_date exact format_text holidays index indirect ltv mass delete match minute months multiple named ranges number num_digits pmi pmt range range_lookup return_type rounding search_key second separate serial_number significance start_date Subtract if sumif sum_range table text tips value weekend xlookup year _xlfn