Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP function - I think
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP function - I think
Set up a column with the answers to the questions. Let's assume there are 25
questions so there would be 25 answers. Let's assume the 25 answers are in the range X1:X25. A1 = answer number you want (from 1 to 25) This formula entered in B1 will return the corresponding answer: =INDEX(X1:X25,A1) You might want to make it more robust by only recognizing values in A1 that are in fact the numbers 1 to 25. =IF(AND(INT(N(A1))=A1,A1=1,A1<=25),INDEX(X1:X25,A 1),"Invalid Entry") -- Biff Microsoft Excel MVP "UK Mike" <UK wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
lookup function .... I think??? | Excel Worksheet Functions | |||
lookup function | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Lookup Function | Excel Worksheet Functions |