Excel Function: INDIRECT

[pdupre1961]

Apologies if this has been mentioned before:

In video http://www.betangel.tv/video/trading-on ... runders-ss, I noticed Peter was having a problem with pointing to the correct worksheet, you can use this excel function to do the work for you: INDIRECT

replace
=IF('Bet Angel (6)'!B1="","",'Bet Angel (6)'!B1)

with
=IF(INDIRECT("'Bet Angel ("&C12&")'!B1")="","",INDIRECT("'Bet Angel ("&C12&")'!B1"))

where C12 is the sheet number - in this example 6 is in cell C12.

Hope this helps someone with copying formulas down the page. I use is a lot now instead of editing Bet Angel sheet numbers.

[pdupre1961]

I take it that no-one understands this function.

It's actually very useful.

[MarketTrader]

Yep.

I use this all the time to solve certain problems.

I didn't realise you were after a response? Are you having trouble using the function?

[pdupre1961]

Yep.

I use this all the time to solve certain problems.

I didn't realise you were after a response? Are you having trouble using the function?

No, I started using it for Bet Angel spreadsheets. So, that I don't have formulas with Bet Angel (1), Bet Angel (2) etc.

I just thought it may useful for others...I will say no more (unless requested to).

[EyePeaSea]

It's actually very useful.

Thanks for posting this. It is very useful. It's one of those things - once you find out about it, you'll always find uses for it.

Cheers

Ian