IFS SWITCH XLOOKUP - which is better?

More about Excel Features

. What are the XLOOKUP & VLOOKUP functions in Excel?

The XLOOKUP and VLOOKUP functions in Excel are used to find, or 'lookup', a value from a table or a list and then return a related result. In this resource, we’ll discuss XLOOKUP vs VLOOKUP with examples of how to use each.

https://www.goskills.com/Excel/Resources/Xlookup-vs-vlookup

XLOOKUP just killed VLOOKUP: everything to know about this major new Excel function

Microsoft recently announced the upcoming release of a new function called XLOOKUP. This function will be replacing the widely used VLOOKUP, HLOOKUP and INDEX/MATCH functions to run searches in a table of Excel data.

https://www.powerusersoftwares.com/post/xlookup-just-killed-vlookup-everything-to-know-about-this-major-new-excel-function