How do I copy a formula with increasing worksheet numbers

Harrison_05 · Apr 29, 2006

My worksheets are numbered 1 - 25.

my formula is: =IF(B$3='1'!$E$6,1,0). I want to copy this formalu into the
next column and have the worksheet name automatically change from 1 to 2.
Is this possible?

Biff · Apr 30, 2006

Hi!

Try this:

=IF(B$3=INDIRECT("'"&COLUMNS($A:A)&"'!E6"),1,0)

Biff

Harrison_05 · Apr 30, 2006

Thanks Biff - don't understand how it works but it does! Will have to
research the INDIRECT command.

Harrison_05