98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup, Xlookup and Hlookup
Vlookup, Xlookup and Hlookup
Resolved · Medium Priority · Version 365
Tue 5 Nov 2024, 16:23Delegate Innocent said...
Innocent has attended:
Excel Intermediate course
Vlookup, Xlookup and Hlookup
Comparing Vlookup and Xlookup which is the best
Tue 5 Nov 2024, 16:34Trainer Jens said...
RE: 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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:New to Excel 2010 - Sparklines!Excel 2010 includes a new feature called Sparklines which are tiny charts that fit into a single cell and plot data in cells from the worksheet. There are a host of formatting and styles that can be applied to them and they are really quite interesting. |
