In this video, we are explaining one of our client's problems in Excel.
How to extract data from unstructured tables without using VBA.
✅ Formulas Used: INDEX, MATCH, and VLOOKUP
✅ This video is beneficial for everyone interested in learning advanced Excel.
For more information visit our website - https://mdatafinnovatics.com/
Download Excel File - https://docs.google.com/spreadsheets/d/1mWEcgBPqVTXhFebyf_xXo-Ya02XEuWCF/edit?usp=sharing&ouid=109431719619751616704&rtpof=true&sd=true
-----------------◀◀◀ YouTube Playlist ▶▶▶-------------
ADVANCED EXCEL LATEST VIDEOS - https://bit.ly/3tRuOJ5
EXCEL FORMULAS & FUNCTIONS - https://bit.ly/33lp6UZ
USE MULTIPLE FORMULAS TOGETHER - https://bit.ly/350p0Cy
EXCEL SHORTS | EXCEL TIPS & TRICKS - https://bit.ly/3nx2ojd
EXCEL TOOLS - https://bit.ly/350Dp1z
-----------------------⬅◀◼Blogs◼▶➡-----------------------
https://mdatafinnovatics.com/blog/
How to get the List of All sheets with Hyperlink Automatically / How to create indexing in Excel - https://www.mdatafinnovatics.com/list-of-all-sheets/
----------------✉️✉️✉️Contact Us✉️✉️✉️---------------
EMAIL ADDRESS: [email protected]
#dropdownlist #exceldatavalidation #excelinhindi