Formula filling for sequential worksheets

  • Thread starter Thread starter Renen Bassik
  • Start date Start date
R

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.
 
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
 
That should be Indirect (B1 & "!$C$2:$H$20") - dont
forget the exclamation mark(!)!

Cheers
Paul
 
Back
Top