Formula filling with 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.
 
=IF(ISNA(VLOOKUP($B15,Indirect("Question" & column(A1) &
"!$C$2:$H$20"),,FALSE)),"","X")

if by adjacent you mean to the right. If you mean below, change column(A1)
to row(A1)
 
Back
Top