excelisfun | Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function? @excelisfun | Uploaded 1 year ago | Updated 3 days ago
Download Excel File: https://excelisfun.net/files/EMT1835-1837.xlsx
Learn about how to lookup a row using CHOOSECOLS, INDEX, FILTER or XLOOKUP functions.
Topics:
1. (00:00) Introduction
2. (00:19) Viewer Question
3. (00:38) CHOOSEROWS and XMATCH
4. (01:23) XLOOKUP
5. (02:06) INDEX and XMATCH
6. (03:00) FILTER
7. (03:37) See that all these methods work in SUM function to add sales for the month
8. (04:01) 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