excelisfun | Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832 @excelisfun | Uploaded 1 year ago | Updated 1 day ago
Download Excel File: https://excelisfun.net/files/EMT1828-1832.xlsx
Learn about how to rearrange multiple lookup tables to allow you to use the FILTER function to lookup multiple tables, then use LOOKUP to do approximate match lookup.
Topics:
1. (00:00) Introduction
2. (00:53) rearrange multiple lookup tables to allow you to use the FILTER function
3. (01:08) Filter Function to lookup multiple tables
4. (02:13) LOOKUP to do approximate match lookup
5. (02:52) Summary of five LOOKUP videos
6. (03:22) 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 #filter #filterfunction #tables #multiple