SOLVED
Home

Trying to automate a spreadsheet based on Column A

%3CLINGO-SUB%20id%3D%22lingo-sub-331147%22%20slang%3D%22en-US%22%3ETrying%20to%20automate%20a%20spreadsheet%20based%20on%20Column%20A%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331147%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20essentially%20what%20I%20am%20trying%20to%20set%20up%2C%20is%20something%20for%20my%20robotics%20team%2C%20what%20I%20am%20struggling%20to%20do%20is%20essentially%20make%20it%20so%20if%20A2%20says%2C%20for%20example%2C%20The%20Cheesy%20Poof%2C%20it%20would%20go%20to%20the%20corresponding%20tab%20called%20The%20Cheesy%20Poof%2C%20and%20then%20pull%20data%20from%20that%20tab%20and%20run%20it%20through%20that%20function%20(so%20average%2C%20or%20countif%2C%20etc)%20.%20Each%20different%20row%20would%20run%20different%20data%20from%20different%20Tabs%2C%20based%20upon%20what%20Column%20A%20Row%20X%20says.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%2C%20an%20example%20spreadsheet%20to%20show%20what%20I%20am%20trying%20to%20do%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-331147%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20question%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331681%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20automate%20a%20spreadsheet%20based%20on%20Column%20A%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331681%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20create%20a%20extra%20column%20where%20the%20extra%20characters%20are%20aded%20to%20make%20it%20possible%20to%20use%20a%20INDIRECT%20formula%20to%20use%20in%20your%20COUNTIF.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E
SenpaiYoshi
Occasional Visitor

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
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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies