SHOULD VLOOKUP BE BURIED OR JUST BE LEFT IN THE MORTUARY?
A few days ago, precisely at noon (GMT) on the 28th of Aug, 2019, Microsoft released a new function the XLOOKUP to Excel insiders.
As a teacher of Excel, I was keen and have just watched the preview by Bill Jelene (Mr Excel).
This sure is a crazy function, it has rubbished our popular VLOOKUP function. I thought the INDEX and MATCH functions were VLOOKUP’s greatest conqueror, then I stumbled on DGET last year after one of my training classes with one of Nigeria’s big banks. I concluded that DGET is in strong competition with INDEX and MATCH in the fight for supremacy over VLOOKUP.
And now Boooom, XLOOKUP has landed, after watching the preview, I knew the time has come for progressive spreadsheet users to either bury VLOOKUP or just let it lie in the morgue. For me I have left VLOOKUP for the foundation excel users, I am even thinking of taking it out of my Advanced Excel module, except that the average Nigerian user still sees VLOOKUP as a little King. I want to talk INDEX and MATCH, I want to talk DGET and I want to discuss XLOOKUP when it finally hits the table of the masses. VLOOKUP, you be old school, I don waka, I have moved on …this is August 2019.
XLOOKUP can look leftward with ease; an impossible task for my VLOOKUP friend, XLOOKUP do not rely on column index number so the problem of breaking the chain when a new column is inserted between the selected data array no longer exist…waooo…… I hail you Bill Gate.
Let’s take a look at the logic syntax of XLOOKUP:
=XLOOKUP(lookup_value, lookup_array, return_array, [match_mode], [search_mode])
Now the fight for supremacy in the LOOKUP functions is certainly between INDEX AND MATCH and XLOOKUP and probably DGET also. Let the context continue.
NB: If you will like to receive our periodic articles on ms excel, pls send an SMS to 08178202020 with the subject “SUBSCRIBE” stating your email address
Dan Karo Ezuzu
Tabs & icons Consulting, Lagos.
Another feather to Tabs & Icons Consulting as it gets accredited by the Chartered Institute of Bankers of Nigeria (CIBN) along with 9 other companies to render Training Services for the Banking and Finance Industry.
The picture shows the President/Chairman of Council, CIBN- Prof. Segun Ajibola, FCIB, Present the certificate of accreditation to the Managing Consultant Tabs & icons Consulting, Mr Dan Karo Ezuzu, FCA. Others in the picture are Head Business Development Tabs & icons Consulting, Mrs Bukola Boyejo, Registrar/Chief Executive- Mr Seye Awojobi, FCIB, Chairman, CIBN Capacity Building & Certification Committee - Prof. P.O Olanrewaju, PhD, FCIB.
Other Companies accredited along with Tabs & Icons Consulting are Wema Bank (Wema Purple academy), Nigerian Interbank Settlement System, HR Index Ltd, Ndackson & Co, Poise Nigeria Ltd, Resource Intermediaries Ltd, DataPro Ltd, Workforce Management Ltd and Ijewere & Co.