Build a formula with a variable using a cell value

[drumsmasher]

Hi gurus,

I've been silently using this website to build my VBAs and formula, BIG THANKS TO EVERYBODY. I have a question that I think it hasn't been asked here yet.

I have the following formula that I'd like to use a variable based on a cell value that will be translated to a sheet name.

=IF(COUNTIF('Timeline Template'!I10:I15,"In-Progress")>=1,"Started",IF(COUNTIF('Timeline Template'!I10:I15,"Completed")=6,"Completed","Not started"))

The sheet name is "Timeline Template" but I'd like to it to look into a sheet named after a cell value that was previously created using a macro.

Thanks all.

 

[Joe4]

Welcome to the Board!

You can use the INDIRECT reference to do that.
See here for an explanation and examples of how to do this: Excel formula: Dynamic worksheet reference | Exceljet