U
UK Mike
Hi
I am trying to set up a worksheet that allows me to type in a question
number in one cell (that the student has got wrong) and in the next cell
gives the answer. Tried looking through the help pages but not sure which
formula to use. I assume that the formula should be in the second cell. I
have about 150 questions I want to use and idealy the answers would be in
another sheet (although not necessarily - they can be just in another
column). For example:
If I type "1" in column A, column B would then say "25" (the answer to
question 1), if I type "2" in column A, column B would then say "36" (the
answer to question 2), etc.
Hope you guys can help.
Thanks a lot.
Mike
I am trying to set up a worksheet that allows me to type in a question
number in one cell (that the student has got wrong) and in the next cell
gives the answer. Tried looking through the help pages but not sure which
formula to use. I assume that the formula should be in the second cell. I
have about 150 questions I want to use and idealy the answers would be in
another sheet (although not necessarily - they can be just in another
column). For example:
If I type "1" in column A, column B would then say "25" (the answer to
question 1), if I type "2" in column A, column B would then say "36" (the
answer to question 2), etc.
Hope you guys can help.
Thanks a lot.
Mike