[Year 12 IT Apps] IARTV exam Q8

[Mark Scott]

Should be  =VLOOKUP(E2, $B$8:$C$12, 2)

Or better still =VLOOKUP(E2, Conversion_Table, 2) where Conversion_Table
is anamed range

Mark Scott

-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Mark Kelly
Sent: Thursday, 20 September 2007 10:11 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] IARTV exam Q8

The solution of Q8b has 2 errors in it, IMO.

It should be =VLOOKUP(E2, B8:C12, 2)

--
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia Direct line / Voicemail:
8520 9085 School Phone +613 8520 9000 School Fax +613 95789253 kel AT
mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au IT Lecture notes:
http://vceit.com
Moderator: IT Applications Mailing List

It's 'i' before 'e' except after 'c'.
Spelling is not an art, it's a sceince.

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe IT
Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology
Teachers Association Inc