• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

v like lookup, gather info across sheets

LegoMason

New Member
Hello,
I need to make a summary sheet which pulls based on the row heading (which is the sheet name) and the column heading (which is the identifier of the data in the sheets) I don't need to add the numbers together I just need a quick way of populating the information. I attached an sample data file which is like 1% of all my data (hence the need to automate this task).

Thank you!
 

Attachments

bosco_yip

Excel Ninja
Try,

In "Summary" sheet C2, enter formula copied across and down :

=IFERROR(VLOOKUP(C$1,INDIRECT("'"&$A2&"'!$A$1:$C$50"),3,0),"")

Regards
Bosco
 

GraH - Guido

Well-Known Member
Your formula is
=IFERROR(VLOOKUP(C$1,INDIRECT(""&$A2&"'!$A$1:$c$50"),3,0),"")
Bosco's was:
=IFERROR(VLOOKUP(C$1,INDIRECT("'"&$A2&"'!$A$1:$C$50"),3,0),"")
 

bosco_yip

Excel Ninja
Or, highlight/enlarge the difference as in :

Your formula is :
=IFERROR(VLOOKUP(C$1,INDIRECT(""&$A2&"'!$A$1:$c$50"),3,0),"")

My (Bosco's) was:
=IFERROR(VLOOKUP(C$1,INDIRECT("'"&$A2&"'!$A$1:$C$50"),3,0),"")

Regards
 
Last edited:
Top