Use cell value as another cell reference?

[stockjos]

Hi!

I've seen the solution most likely is the INDIRECT function but I am having a hard time getting it working. The formula in cell J14 is:

='IS, BS, CF Comb - mthly fcst'!CI205

This calling a value from another tab but if I want to create a chart at the bottom of this sheet where I would have 'CI' in cell D100, then I could change that 'CI' to 'CJ', so then my formula would look for the value in CJ205 from the other tab.

Need help with that syntax...

Thanks!
Joe

 

[=ODIN=]

Try this:

[COLOR=#333333]=indirect("'IS, BS, CF Comb - mthly fcst'!" & d100 & "205")[/COLOR]

 

[stockjos]

HA!!! What exciting times we live in!!!!!!!!

Thanks!!!