Vlookup, Xlookup and Hlookup

Hi Innocent,

Thank you for the forum question and the nice feedback. I am happy that the course was useful.


Both VLOOKUP and HLOOKUP are awful functions. They get your Excel files slow and get your Excel files crash. They use a lot of memory.

The XLOOKUP is both a horizontal and a vertical lookup. It can do much more than VLOOKUP and HLOOKUP and is much more efficient when it comes to use of memory.

I have stopped using VLOOKUP and HLOOKUP after we got the XLOOKUP.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector