XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833

Download Excel File: https://excelisfun.net/files/EMT1833-1834.xlsx
Learn how to use the worksheet tab name as the lookup value in XLOOKUP or VLOOKUP..
Topics:
1. (00:00) Introduction
2. (00:24) CELL Function
3. (01:21) TEXTAFTER Function
4. (01:49) RELPACE and SEARCH functions.
5. (02:22) XLOOKUP or VLOOKUP
6. (03:27) Copy Lookup Formula
7. (04:13) Summary
8. (04:26) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula