Learn Excel XLOOKUP function inside out from this series of training videos. You will learn from the basic and simple form of XLOOKUP, all the way to the advanced usages of XLOOKUP function.
The XLOOKUP Inside Out series contains below lessons:
1: Vertical Lookup • Learn Excel XLOOKUP In...
2: Horizontal Lookup • Learn Excel XLOOKUP In...
3: Match Not Found • Learn Excel XLOOKUP In...
4: Partial Match • Learn Excel XLOOKUP In...
5: Lookup from Last to First • Learn Excel XLOOKUP In...
6: Match Next Smaller • Learn Excel XLOOKUP In...
7: Match Next Larger • Learn Excel XLOOKUP In...
8: Return Array of Multiple Values • Learn Excel XLOOKUP In...
9: Two-Dimensional Lookup • Learn Excel XLOOKUP In...
10: Lookup Multiple Fields • Learn Excel XLOOKUP In...
11: Return Multiple Matches by FILTER • Learn Excel XLOOKUP In...
12: Lookup Text as Number • Learn Excel XLOOKUP In...
13: Lookup Number as Text • Learn Excel XLOOKUP In...
14: Lookup Both Text & Number • Learn Excel XLOOKUP In...
15: Lookup Picture & Return Pictures • Learn Excel XLOOKUP In...
16: Lookup from Multiple Sheets • Learn Excel XLOOKUP In...
Please use this link to access the accompanying training Excel files to practice along: www.superexcel...