Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
Can somebody please tell me how this workshhet is layed out and how it works
because im really struggling as i want to do the same to make another quiz formy school work. http://www1.edexcel.org.uk/spbs2007/...ality_Quiz.xls dont worry its from the DiDA site and is not harmful |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
Hi,
Setting aside whether the calculated profile is of any practicable value the way it works is very eimple. the values a user gives to the 15 questions are summed in the range D35 to D39 with each question being assigned to one of the 5 categories Active Likes company Caring Intellectual Perseverence base upon the sum of the values the worksheet then does 10 lookups, 2 for each of those categories and returns some text that is supposed to profile the user against each of the categories. The text categories are in the hidden rows in lookup tables. Mike "confused" wrote: Can somebody please tell me how this workshhet is layed out and how it works because im really struggling as i want to do the same to make another quiz formy school work. http://www1.edexcel.org.uk/spbs2007/...ality_Quiz.xls dont worry its from the DiDA site and is not harmful |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |