👉ADVANCED LOOKUP - INDEX AND MATCH FUNCTION
The VLOOKUP function looks up a value in the left column of a range or table and returns the corresponding value from a column to the left.
Due to the limitation of the VLOOKUP function that only looks to the right, the INDEX & MATCH function can be used to perform a more advanced lookup.
In this lesson, I will show you how to use the INDEX & MATCH function to lookup the value in any column and return the corresponding value to the left, simply use the INDEX and MATCH
You can download the workbook used in this tutorial via this link 👇
https://accountingonexcel.ng/advanced...
Ensure you work along to better understand the Excel Function and features used in this lesson.
Will be glad to get your feedback in the comment section. You must know that I read all comments and will definitely reply.
Use the SUBSCRIBE button and notification bell 🔔 to get a prompt notification on all my videos on this channel
Use the link below to JOIN our community of Smart Excel Users Network 👇
/ smart. .
Social Platforms:
Subscribe to YouTube: http://bit.ly/AccountingandExcelVila
Facebook: http://bit.ly/SmartExcelUsersNetwork
YouTube: http://bit.ly/amakaifebunandu-youtube
LinkedIn: / amakaifeb. .
Twitter: / dexcelcoach
Instagram: / dexcelcoach
#VLOOKUP
#INDEX
#MATCH
#INDEX&MATCH
#ExcelFormulas
#dexcelcoach