Setting a formula to use a "column" set in a cell

[jack109]

Hi

Is there a way to reference a column to be used by using a cell.

For example if G is in B2, then G used in the formula

eg. =SUM(G2:G12)

If B2's value was P then the formula would change to =SUM(P2:P12)

I've tried searching online but I'm finding it hard to word it without providing the above example

Cheers

 

[Joe4]

Sorry, typo. Yes. I meant INDIRECT, not INDEX.

You don't need a helper column - you just have your parentheses in the wrong place (if you had used the method of first building the range address, you should have gotten it right), i.e.

=IF(INDIRECT(B2&ROW())=100,"yes","no")

 

[jack109]

Sorry, typo. Yes. I meant INDIRECT, not INDEX.

You don't need a helper column - you just have your parentheses in the wrong place (if you had used the method of first building the range address, you should have gotten it right), i.e.

=IF(INDIRECT(B2&ROW())=100,"yes","no")

Thank you for the assistance and PATIENCE lol , much appreciated!!!

 

[Joe4]

You are welcome.

Remember, first build the formula that returns the range address looking exactly the way you want it.
Then, wrap that whole expression (and just that expression) in INDIRECT(...)
Then, you can build other formulas around that.