Formula filling for sequential worksheets

[Renen Bassik]

I have a formula in a worksheet:
=IF(ISNA(VLOOKUP($B15,Question1!
$C$2:$H$20,,FALSE)),"","X")
in which it is doing a look up at a worksheet
called "question1"

in another cell adjacent I would like it to perform the
same but look at worksheet "question2"

Simply:How can I fill a formula across and have it look
at the next worksheet in a sequence?

A little more difficult yet more generic in use:
programming the function to allow the user to insert the
name of the function as a sub function either
sequentially or in some list it can pull from.

 

[GB]

Put 'Question 1' in Cell B1 or some other convenient row. Drag across to
make Question 2, Question 3 etc in cells C1 D1 etc

Replace Question1!$C$2:$H$20 in your formula with

Indirect (B1 & "$C$2:$H$20")

HTH

Geoff

 

[Paul]

That should be Indirect (B1 & "!$C$2:$H$20") - dont
forget the exclamation mark(!)!

Cheers
Paul

 

[GB]

That should be Indirect (B1 & "!$C$2:$H$20") - dont
forget the exclamation mark(!)!

Cheers
Paul

Oops! Thanks.

Geoff