Blog Archives

Tom’s Tutorials For Excel: Showing how Excel’s FILTER function extracts different combinations of “and” and “or” criteria records within a single formula.

Keywords: Excel 365; FILTER; if_empty; AND; Asterisk; OR; Plus +

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , ,

Tom’s Tutorials For Excel: Explaining Excel’s FILTER function to extract multiple “or” criteria records, by using the plus + operator.

Keywords: Excel 365; FILTER; if_empty; OR; Plus +

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , ,

Tom’s Tutorials For Excel: Explaining Excel’s FILTER function to extract multiple “and” criteria records, by using the asterisk * operator.

Keywords: Excel 365; FILTER; if_empty; AND; Asterisk

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , ,

Tom’s Tutorials For Excel: Using XLOOKUP for horizontal lookups.

Keywords: Excel 365; XLOOKUP; horizontal; HLOOKUP; Data Validation; Conditional Formatting

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , ,

Tom’s Tutorials For Excel: Showing a double XLOOKUP (XLOOKUP with nested XLOOKUP) for an intersecting horizontal with vertical lookup.

Keywords: Excel 365; XLOOKUP; Intersect; Row; Column; Data Validation; Conditional Formatting

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , ,

Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula.

Keywords: Excel 365; Excel 365; XLOOKUP; match_mode; math

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , ,

Tom’s Tutorials For Excel: Showing a double XLOOKUP (XLOOKUP with nested XLOOKUP) for an intersecting horizontal with vertical lookup.

Keywords: Excel 365; Excel 365; XLOOKUP; Intersect; Row; Column; Data Validation; Conditional Formatting

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , ,

Tom’s Tutorials For Excel: Showing XLOOKUP’s optional sixth argument named search_mode and its four search options for reverse (right-to-left) and forward (left-to-right) lookups.

Keywords: Excel 365; XLOOKUP; search_mode; Binary; Conditional Formatting

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , ,

Tom’s Tutorials For Excel: Exampling XLOOKUP for combined wildcard lookup_values of question mark “?” and asterisk “*” characters for reverse (right-to-left) and forward (left-to-right) lookups.

Keywords: Excel 365, XLOOKUP, match_mode, Wildcard, Question, Asterisk

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , ,

Tom’s Tutorials For Excel: Using XLOOKUP with the asterisk “*” wildcard character for reverse (right-to-left) and forward (left-to-right) lookups.

Keywords: Excel 365; XLOOKUP; match_mode; Wildcard; Asterisk

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , ,

Tom’s Tutorials For Excel: Using XLOOKUP with the question mark “?” wildcard character for reverse (right-to-left) and forward (left-to-right) lookups.

Keywords: Excel 365; XLOOKUP; match_mode; Wildcard; Question

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , ,

Tom’s Tutorials For Excel: Explaining the XLOOKUP function’s if_not_found optional fourth argument for reverse and forward lookups.

Keywords: Excel 365; XLOOKUP; if_not_found

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , ,

Tom’s Tutorials For Excel: Understanding the XLOOKUP function’s match_mode optional fifth argument for exact and inexact matches.

Keywords: Excel 365, XLOOKUP, match_mode

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , ,

Tom’s Tutorials For Excel: Explaining the XLOOKUP basics: reverse (right-to-left) and forward (left-to-right) lookups.

Keywords: Excel 365; XLOOKUP; Conditional Formatting; Data Validation

Click here or the picture to download this free, safe, interactive workbook.

…

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , ,