Chris has attended:
Excel Advanced course
V Lookup
Is there a formula which is preferred to V lookup? I believe I remember YENS saying that V lookup was slow and that there where other formulas which where better and did the same job? Maybe MATCH?
RE: V Lookup
Hi Chris,
Thank you for the forum question.
Yes the Vlookup can slow down everything in Excel if you work with many records. A much more efficient option is a Index function together with a Match function, but it is also a more complicated option. Index/match can also do much more than the Vlookup.
I found a video on YouTube which very well explain this.
https://www.youtube.com/watch?v=WSqcZbpoV0M
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
