[Year 12 IPM] Excel task (advanced)... U2O1 and U4O1 practice

[Mark Kelly]

A deceptively simple task that gets more difficult as you get into it. 
Might be good as a challenge for your better students.

Tell them they are NOT allowed to use an IF anywhere in their solution!

It shows the use of nested VLOOKUPs.  Task and solution attached...

Have fun.

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria Australia
Phone +613 95780844  Fax +613 95789253
Webmaster: http://www.mckinnonsc.vic.edu.au
IPM Lecture notes: http://vceit.com
Moderator: IPM Mailing List

Gosh you’re cute. Wanna buy a monkey?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: salary spreadsheet.xls
Type: application/vnd.ms-excel
Size: 15360 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050617/a8a73f9d/salaryspreadsheet-0001.xls
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SALARY SPREADSHEET.doc
Type: application/msword
Size: 33280 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/ipm/attachments/20050617/a8a73f9d/SALARYSPREADSHEET-0001.doc