Lookup values across multiple worksheets with dynamic sheet name
In many cases, you may need to collect data across multiple worksheets for summary. With the combination of the VLOOKUP function and the INDIRECT function, you can create a formula to lookup specific values across worksheets with dynamic sheet name.
How to lookup value across worksheets with dynamic sheet name?
Supposing you have four worksheets containing sales for different salesmen in four seasons as the below screenshot shown, and now you need to collect the sales for all salesmen across these four worksheets and return them into a summary worksheet. Here is the solution step by step for you.
Lookup values from another worksheet or workbook If you want to lookup values from different worksheet or workbook, this tutorial will do you a favor. Click to know more...
Excel dynamic worksheet or workbook reference Supposing you have data with the same format across multiple worksheets or workbooks and need to get data from these worksheets or workbooks dynamically into another sheet. This article will help you quickly get it done. Click to know more...
Vlookup formula – the shipping cost calculator This article provides detailed steps to calculate shipping cost based on specified weight of an item in Excel. Click to know more...
Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300 powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) and save 80% time for you.
Designed for 1500 work scenarios, helps you solve 80% Excel problems.
Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
30-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years.