How to use Indirect along with VLookup Function to consolidate data across various sheets

Generally, you can use it to look up one sheet at a time. However, modifying the data allows us to use VLOOKUP across multiple sheets in Excel. As the formula is copied down and across, VLOOKUP retrieves the correct values from each sheet. The INDIRECT function tries to evaluate text as a worksheet reference. You may need to perform a VLOOKUP on multiple ranges at once, dependent on certain cell values. If so, one option is the INDIRECT Function, which can be used to define a lookup range, or even create a dynamic reference to multiple sheets. The INDIRECT function in Excel helps the users to lock the specified cell in a formula. Therefore, without changing the formula itself, we can modify cell references within a formula. This makes it possible to build formulas that assemble a reference as text using concatenation, and use the resulting text as a valid reference. In this video you will learn how to use Indirect along with VLOOKUP Function to consolidate data across various sheets in Excel. Use of VLOOKUP Function, use of INDIRECT Function in VLOOKUP formula.