Download Excel File: https://excelisfun.net/files/EMT1760.xlsx
Learn how to create an advanced array formula to spill two-way lookup results using VLOOKUP, MAP, LAMBDA and XMATCH Microsoft 365 functions. As of Monday, October 11, 2021, the MAP function is only in Microsoft 365 Insider Edition of Excel.
Topics:
1. (00:00) Introduction.
2. (00:41) Why VLOOKUP with function argument array operations does not work.
3. (01:29) How we will solve the VLOOKUP problem.
4. (01:42) MAP function
5. (02:14 )LAMBDA function
6. (02:26) VLOOKUP and XMATCH function
7. (03:40) Spill the array
8. (03:57) Conclusion
9. (04:14) Thanks to Excel Lambda for this formula!