The best way to learn is by doing. Here are reputable sources where you can download XLOOKUP example workbooks: XLOOKUP Practice Exercises – Free Excel XLS Download
Includes a built-in "if_not_found" argument to replace #N/A with custom text. Free XLOOKUP Practice Files for Download download xlookup example
Released in 2020, XLOOKUP was designed to replace VLOOKUP, HLOOKUP, and even INDEX/MATCH. Unlike its predecessors, XLOOKUP: The best way to learn is by doing
It can look to the left or right, and up or down. XLOOKUP was designed to replace VLOOKUP
No more worrying about that pesky FALSE at the end of your formula.
One formula can "spill" results across several cells.