Vlookup

[confused]

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/d201-test/documents/links/Personality_Quiz.xls

dont worry its from the DiDA site and is not harmful

 

[Mike H]

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