Use INDIRECT to Reference Sheets Within VLOOKUP

http://www.computergaga.com/ Use the INDIRECT function to reference sheets within the VLOOKUP function. You can perform a VLOOKUP across the sheets of a workbook by nesting the INDIRECT function. This will include the sheet name within the table array reference of the formula.