Formula examples to Vlookup from another worksheet or workbook, Vlookup in multiple sheets, and indirect Vlookup to dynamically pull data from several worksheets into different cells.