Still confused how to use Xlookup in Excel. Learn how to use in 20 seconds. =XLookup(Lookup_value, lookup_array, return_array) Lookup Value - what are you looking for Lookup Array - range of cells where you want Excel to search for lookup value Return Array - range of cells from where you get the final result #msexcel #exceltok #exceltips #spreadsheet #xlookup #xlookupexcel