Hae comrades/meshers let's discuss yesterday's Microsoft excel tips each in detail ,with pictures

1. XLOOKUP

XLookup is better than VLOOKUP or Index & Match. Use it to perform both VLOOKUPs or HLOOKUPs.

Formula: =XLOOKUP (lookup value, lookup array, return array)