Excel made easy

Database of Excel tips and tutorials.

Excel tips

Latest Excel Tips and Tutorials

XLOOKUP Training

Learn about XLOOKUP

Learn how to use the XLOOKUP function in Excel. See for yourself why this new function makes Excel that much easier.


  1. XLOOKUP with Multiple Criteria
    Perform an XLOOKUP with multiple Criteria using concatenate features in Excel
  2. XLOOKUP Horizontal Lookup
    With XLOOKUP, you no longer have to use the very limited HLOOKUP function.
  3. XLOOKUP Function in Excel
    XLOOKUP replaces VLOOKUP AND HLOOKUP permanently!
  4. Fix XLOOKUP #SPILL Error
    Learn to easily fix an XLOOKUP #SPILL Error in Excel.

camera tool ceiling concatenate criteria date dates DAYS dynamic EMI end_date exact format_text holidays index indirect ISOWEEKNUM match minute month months multiple named ranges networkdays.intl number num_digits pmt range range_lookup return_type Reverse CAGR second serial_number significance start_date Subtract if sumif sumif date sumifs date sum_range table time_text tips value weekend _xlfn

Scroll to Top