47,326 views
Searching using the INDEX+MATCH function in more than one sheet and more than one worksheet in Excel There is no doubt that lookup multiple sheets or searching in more than one Excel sheet is one of the biggest obstacles facing many people who work in the field of data analysis using the Excel program, as in some situations you realize that there is a large number of worksheets in Excel, for example, and you want to search or use a function such as INDEX+MATCH on all worksheets, and this requires great effort in the event that each equation is used in each sheet separately, but in this video we will explain how to search in more than one sheet using the INDEX+MATCH function and the Indirect function, and the result will be greatly variable. To download the work file https://bit.ly/3nepfB7 To contact me [email protected] ???? Subscribe to the channel to receive all new videos https://bit.ly/3fAUJus ???? Facebook group / excelonline1