Appear up a value vertically and horizontally (and to the left)…
Excel ultimately has a more intuitive and handy research perform, with the new XLOOKUP instrument now commonly out there for Microsoft’s 200 million-additionally Office environment 365 people.
XLOOKUP replaces VLOOKUP (explained by Microsoft a contact excitedly as “iconic”) a instrument that is the 3rd most-utilised perform in Excel, after SUM and Regular.
The latter’s flaws are properly documented and include defaulting to an “approximate” match instead than an specific match. VLOOKUP also are not able to glimpse to the left: it normally searches the to