46,773 views
Searching using the VLOOKUP function in more than one sheet in Excel There is no doubt that lookup multiple sheets or searching in more than one Excel sheet is considered one of the biggest obstacles that many face, as in some situations you realize that there are more than 20 Excel sheets, for example, and you want to search or use a function such as Vlookup on all the worksheets, and this requires a lot of effort in the case of using each equation in each sheet separately, but in this video we will explain how to search in more than one sheet using the Vlookup function and the Indirect function, and the result will be greatly variable. To download the work file https://bit.ly/3eKYxZz Facebook Group / excelonline1