The videos below demonstrate this shortcut.

Video thumbnail for XLOOKUP with boolean logic

Video thumbnail for The SEQUENCE function

Video thumbnail for Conditional formatting with one variable input

Video thumbnail for How to use INDEX and MATCH with a table

Video thumbnail for TEXTAFTER and TEXTBEFORE advanced options

Video thumbnail for FILTER with boolean logic