Indirect formula returns 0 instead of value

[ahkisha]

I'm trying to create a summary sheet with a table that returns the same cell in each sheet. My sheets are called: June 2016, July 2016, etc

I have created a table where names of the sheet start in C2, A3 is the cell on each sheet I want to return and my formula is currently: =INDIRECT("'" & C2 & "'!A3"). However when I use this formula, I get a 0 for all the sheets. I have tried with other cells that definitely contain values but it returns 0 each time. Any idea/fixes for this? Thanks!

A......B...........C.................D........... E.....F
1
2 ................June 2016.....July 2016
3 F9.................0
4

[loginjmor]

Hi -

Can you post a sample spreadsheet with any sensitive data removed and a couple examples of what you think the desired outcome should be? It's a little hard to tell from your post why that isn't working. Just checking the obvious, but are you sure there is non-zero data in those sheets in cell A3?

[etaf]

working for me

=INDIRECT("'"&C2&"'!A3")

but if its returning a zero- then that maybe a blank cell

#ref or #value - would be error messages i would expect

[Pete_UK]

That will include the text A3, rather than the cell value of A3. Try it like this:

=INDIRECT("'" & C$2 & "'!" & $A3)

so you can copy this across and down if required.

Hope this helps.

Pete

[ahkisha]

Hello! Thank you for the quick replies, they were all really helpful!

@Pete your response worked like a charm!!! Thank you so much!!

[Pete_UK]

You're welcome - glad to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete