The most used formula in Excel is VLOOKUP. It is also known as the synonym of Excel. Do you know there are so many hidden and smart features of vlookup which can save Days/Hours of our precious time? Let's dive deep into VLOOKUP and master it.
👉 Understanding VLOOKUP Conceptually
👉 Shortcomings of VLOOKUP
👉 Common Mistakes while applying VLOOKUP
👉 How to make Vlookup work Right to Left
👉 Dynamic Lookup - Auto update results even on insert/Delete of column
👉 How to find value from multiple databases based on priority
👉 Vlookup always find 1st matching value, How to find duplicate values
👉 How to get value from multiple sheets dynamically
👉 What to do if exact match is not there, for instance if database values are Dr Sanjeev,
Ms Sonia, XYZ Ltd., but we look for Sanjeev, Sonia or XYZ
👉 Many other unexplored areas
👉 Questions & answers