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 |
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 |
All times are GMT +1. The time now is 08:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com