Power Spreadsheets

In this Excel XLOOKUP in Table Tutorial, you learn how to create an Excel XLOOKUP in Table formula to carry out an XLOOKUP inside an Excel Table. The XLOOKUP function is available in Excel 2021 and later (including Excel 365). This Excel XLOOKUP in Table Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by … [Read more...]

In this Excel Convert Celsius to Fahrenheit Tutorial, you learn how to create an Excel convert Celsius to Fahrenheit formula. This Excel Convert Celsius to Fahrenheit Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by clicking the button below. Related Excel Training Materials and Resources This … [Read more...]

In this Excel XLOOKUP Between 2 Values Tutorial, you learn how to create an Excel XLOOKUP between 2 values formula. The XLOOKUP function is available in Excel 2021 and later (including Excel 365). This Excel XLOOKUP Between 2 Values Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by clicking the button … [Read more...]

In this Excel Convert Cm to Inches Tutorial, you learn how to create an Excel convert cm to inches formula. This Excel Convert Cm to Inches Tutorial is accompanied by an Excel workbook with the data and formulas I use. Get this example workbook (for free) by clicking the button below. Related Excel Training Materials and Resources This Excel Convert Cm to Inches … [Read more...]

In this Excel IF XLOOKUP (for Error Handling) Tutorial, you learn how to create an Excel IF XLOOKUP (for error handling) formula, where you: Combine the XLOOKUP and IF functions; To handle (certain) potential errors (returned by XLOOKUP). The Excel IF XLOOKUP (for error handling) formula template/structure you learn below relies on the XLOOKUP and LET functions. XLOOKUP and … [Read more...]