DEFINITON VLOOKUP:- Vlookup is vertical’ lookup built-in Excel function. VLOOKUP is used when you need to find something in a table or a range by row. For example to look up a item price of an any company part by its item code number, or to find an employee name based on their ID.
To Separately Viewing Please Visit This Posts VLOOKUP IN EXCEL. INDIRECT IN EXCEL
DEFINITON INDIRECT:- INDIRECT function is used in Excel to change over a content string into a legitimate range reference. For example: if you want to lookup what value is available in cell A2 then simply use =INDIRECT(“a2”). Indirect use text reference and actually convert it to reference. So here “a2” is converted to cell(a2).
In This Example :- We will lookup the Shoes value with Vlookup and Indirect function in all the sheets and use the table array in indirect function to make the sheet reference dynamic to extract the price from different sheet, if lookup value is available in that particular sheet. For more detail please check image and video below.
