master certificate class on

xlookup hired - vlookup fired

Course Fee - Rs. 999/- only

Buy Now

Why it's important!

XLOOKUP : 10 Times powerful than VLOOKUP

Left or Right any side Lookup

No need of HLOOKUP

No need of IFERROR

No more INDEX/MATCH

XLOOKUP is part of EXCEL 365 New Dynamic Functions. This is going to change our working tremendously and going to be immensely helpful to automate tasks in our spreadsheets. CHAMP EXCEL is glad to organize ONCE AGAIN a Master CERTIFICATE Class on XLOOKUP HIRED - VLOOKUP FIRED an Interactive Webinars by Eminent Excel Expert and CA Sh. Vijay Agarwal, awarded Microsoft Excel MVP for four consecutive years (2014-18) for his Excel Skills.

We always wished to learn Vlookup well and even after learning still struggling a lot due to its limitations like:

👎 It works only left to right

👎 its very slow,

👎 How to avoid errors like N/A

👎 Inserting or deleting columns make results wrong

👎 Need to learn HLOOKUP

👎 Its find only 1st matching values

👎 What to do if we need to match values on LIFO basis

👎 and many other issues

Salient features of the Course:

👉 Shortcomings of VLOOKUP

👉 Understanding XLOOKUP Conceptually

👉 Apply anywhere Left or Right

👉 No need of using IFERROR

👉 No Need of learning HLOOKUP or INDEX/MATCH

👉 Dynamic Lookup - Auto update results even on inserting/Deleting of columns

👉 How to find value from multiple databases based on priority

👉 Able to Find Last Value 1st like finding last purchase price

👉 How to get value from multiple sheets dynamically

👉 What to do if exact match is not there, like in Data base values are Dr Sanjeev, Ms Sonia, XYZ Ltd., but we look for Sanjeev, Sonia or XYZ

👉 Many other unexplored areas

👉 Some Interesting Business Cases

👉 Q&A

more perks

CERTIFICATION
Obtain a digital certificate for completing this course

WORKING FILES
Get access to the working and business solution files

90 DAYS ACCESS
Get access to the webinar recording for 3 months

INTERACTIVE Q/A
Get answers to all your queries