Excel Formula to Find a Tab

Microsoft Office excel 2007 - upgrade
June 22, 2010 at 08:22:08
Specs: Windows XP
I have an excel workbook with multiple worksheets. The first sheet is a summary page for a project. The information from the summary page is based on information from ONE of the other worksheets. I'd like to be able to type in the tab name and have the summary page look up the values on that one worksheet only - i.e. in cell A1 on the summary page I would type in "Tab 4" to indicate that the calculations being made on the summary worksheet need to be made using the data on the worksheet labeled "Tab 4". In another cell on the summary page I want to be able to look up a value in cell A1 on the Tab 4 worksheet without having to always link back and forth manually every time I re-use this workbook for other projects so I could just change A1 to “Tab 8” and the summary page would update with the applicable data.
I know there is a way to do this but I cannot for the life of me remember how to do it.


See More: Excel Formula to Find a Tab

Report •

June 22, 2010 at 09:03:28
Assuming that cell A1 on the same worksheet contains a valid Tab name, then enter this formula in any cell:

It will return the value in cell A1 from the specified tab

To return the value from cell B2 on the specified Tab use:


Make a drop-down list in cell A1 using data validation, so that you can easily select any valid Tab name.


Report •

June 22, 2010 at 09:34:38
Thank you! It's exactly what I needed. I hate when I know I've done something before but just cannot remember how! LOL!!

Thanks again.

Report •

June 22, 2010 at 10:00:38
You're very welcome


PS It's only time to worry when you can't remember that you did something before - but as you can't remember, it's not worth worrying about :)

Report •

Related Solutions

Ask Question