SOLVED

Trying to automate a spreadsheet based on Column A

Copper Contributor

So essentially what I am trying to set up, is something for my robotics team, what I am struggling to do is essentially make it so if A2 says, for example, The Cheesy Poof, it would go to the corresponding tab called The Cheesy Poof, and then pull data from that tab and run it through that function (so average, or countif, etc) . Each different row would run different data from different Tabs, based upon what Column A Row X says.

 

Here, an example spreadsheet to show what I am trying to do:

 

Thank you so much!

1 Reply
best response confirmed by SenpaiYoshi (Copper Contributor)
Solution

Hi,

 

I have create a extra column where the extra characters are aded to make it possible to use a INDIRECT formula to use in your COUNTIF.

 

See attached

1 best response

Accepted Solutions
best response confirmed by SenpaiYoshi (Copper Contributor)
Solution

Hi,

 

I have create a extra column where the extra characters are aded to make it possible to use a INDIRECT formula to use in your COUNTIF.

 

See attached

View solution in original post