Formula filling with sequential worksheets

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.
 
T

Tom Ogilvy

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top