Using the INDIRECT function

[jdhfch]

Hi,

I am trying to replace a formula in a workbook to use the INDIRECT function to link to other worksheets in the same workbook

This is the formula I am wanting to replace:

=INDEX('Andrew'!$A$7:$R$18,$B$11,18)

This is what I have been trying to replace it with but it returns an error saying too many arguments

=INDIRECT("'"&B12&"'!A7:R18",B11,18)

If I remove the 18 at the end (that is column 18 on thesource worksheet), it does return a value, but of column 1.

Please can you help?

 

[steve the fish]

You still need your INDEX in there. The INDIRECT is just providing an indirect route to the range. It doesnt replace the index.

=INDEX(INDIRECT("'"&B12&"'!A7:R18"),$B$11,18)

 

[jdhfch]

Thank you Steve