Forum Discussion

SenpaiYoshi's avatar
SenpaiYoshi
Copper Contributor
Feb 05, 2019
Solved

Trying to automate a spreadsheet based on Column A

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 corresp...
  • Rich99's avatar
    Feb 06, 2019

    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

Resources