Vlookup multiple sheets with indirect

Download the practice workbook 👉 HERE and follow along.

Let’s say you have a main Excel sheet called “Summary.” This sheet helps you look at specific information from other sheets within the same file.

For example, you might want to see invoiced amounts from different departments.

These include the Game, Productivity, and Utility divisions.

In addition, you want to have the option to choose a month.

Here’s how you can set it up simply:

The “Summary” sheet includes a cell (B4) where you select a month.
Each division has its own sheet named accordingly: Game Div., Productivity Div., and Utility Div.
These division sheets are organized the same way.

They list invoiced amounts month by month.

Your goal is to lookup the invoiced amounts from the relevant division sheet based on the month you’ve selected in the Summary sheet. This setup allows you to view specific financial details quickly and easily.

Why not use the IF Function for a Lookup Across Multiple Sheets

The IF function can help

how to apply vlookup in different excel sheets

how to do vlookup in excel with two sheets using