What is the best lookup function in Excel?

Whether you're an devout user of VLOOKUP or someone known to dabble in the dark HLOOKUP arts, there's something for you in this video.

Here I expose some of the pros and cons of using VLOOKUP, HLOOKUP, INDEX/MATCH, and XLOOKUP when working with data structured vertically or horizontally.

Check this out and let me know what you would like to see me cover next!