Bill Jelen ("Mr. Excel") has posted an in-depth look at XLOOKUP with more examples: https://www.mrexcel.com/excel-tips/the-vlookup-slayer-xlookup-debuts-excel/

Bill Jelen ("Mr. Excel") has posted an in-depth look at XLOOKUP with more examples: https://www.mrexcel.com/excel-tips/the-vlookup-slayer-xlookup-debuts-excel/ https://www.mrexcel.com/excel-tips/the-vlookup-slayer-xlooku... and a video: https://www.youtube.com/watch?v=E5JxX_3Qb7A https://www.youtube.com/watch?v=E5JxX_3Qb7A