Does anyone know how I can bring a cell value into a single sheet based on the name of a number of other sheets. For example, if I have a Base sheet with the names of five sheets in the Book, say 1, 2, 3, 4, 5, in a column, is there a function that would bring cell B2, say, from each sheet of the five sheets, 1,2,3,4,5 into the base sheet next to the named reference 1,2,3,4,5. Apologies for the poor description!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
The Opposite to Vlookup
- Thread starter SimonG
- Start date
6StringJazzer
Well-known Member
- Joined
- Jan 27, 2010
- Messages
- 3,286
- Office Version
- 365
- Platform
- Windows
- Mobile
Actually a pretty good description! Yes, it's the INDIRECT function. Let's say your base sheet has the other sheet names in column A. The formula for row 2 to show the content of B2 in the corresponding sheet:
INDIRECT lets you build a string that looks like a cell/range address and then returns that cell/range. You can look it up in Excel help.
I have not tested it but if you have any trouble I'll set up an example.
Excel Formula:
=INDIRECT("'" & A2 & "'!B2")INDIRECT lets you build a string that looks like a cell/range address and then returns that cell/range. You can look it up in Excel help.
I have not tested it but if you have any trouble I'll set up an example.
Upvote
0
Similar threads
- Solved
