Master Class on XLOOKUP

Course Fee - INR 999/- only 

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 will be immensely helpful to automate tasks in our spreadsheets.


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 

👎 it's very slow, 

👎  How to avoid errors like N/A

👎 Inserting or deleting columns make results wrong

👎 Need to learn HLOOKUP

👎 It's 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

Step 1: Signup

Click on 'Enroll Now' button and do signup first.

Step 2: Payment

After signing up go for payment method.

Step 3: Done

After payment, do register for Live Webinar schedule at 23-05-2021, Sun 6:00pm to 8:30 pm