What the function - XLOOKUP for Excel in simple words
Welcome to what the function - a new series of no nonsense guides on Excel functions.
In the first instalment, let's look at XLOOKUP, the VLOOKUP killer.
Use XLOOKUP to find matching data from your tables or ranges. The syntax for XLOOKUP is,
=XLOOKUP(what you want to lookup, lookup range, result range, optional if error value)
XLOOKUP will return EXACT match by default.
For more information on XLOOKUP, please see this page -
https://chandoo.org/wp/xlookup-examples/
#xlookup #WhatIsXlookup #VlookupAlternative
Watch video What the function - XLOOKUP for Excel in simple words online without registration, duration hours minute second in high quality. This video was added by user Chandoo 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 20,855 once and liked it 572 people.