Worksheet linking?

  • Thread starter Thread starter carla
  • Start date Start date
C

carla

I am making a table in excel and under one heading i have
3 options to choose from. i was wondering if it is
possible to, once someone was to choose option 1, 2 or 3,
that they would then be led to another question that they
must answer. does this make any sense?
for example:
my table has a column header:
nature of complaint:
1 - manner is which service delivered
2 - content of info given
3 - both
if someone chooses 1 can excel bring them to answer
another question in regards to that response?

i hope this helps... i am somewhat new using excel and
all its many features. the response doesn't have to stay
int he same column or can?
any help would be great
thanks :)
carla
 
carla said:
I am making a table in excel and under one heading i have
3 options to choose from. i was wondering if it is
possible to, once someone was to choose option 1, 2 or 3,
that they would then be led to another question that they
must answer. does this make any sense?
for example:
my table has a column header:
nature of complaint:
1 - manner is which service delivered
2 - content of info given
3 - both
if someone chooses 1 can excel bring them to answer
another question in regards to that response?

i hope this helps... i am somewhat new using excel and
all its many features. the response doesn't have to stay
int he same column or can?
any help would be great
thanks :)
carla
Click to expand...

It sounds like you need a VLOOKUP formula to look up the response from the
first question in a pre-defined table somewhere in your workbook. This would
return the next question. If you want to go on from this to a third
question, you would need to combine responses from the first two questions.
If the responses are always numeric and any one is always <=9, you could use
=10*first+second or similar. You would then lookup the combined responses in
another table, etc.
 
Back
Top