Excel 2003: VLOOKUP

The ticks indicate the suitability of resources for each Key Stage.

Resource

KS3

KS4

KS5

Click Here

VLOOKUP Walkthrough 1

 

 
 
tick
tick

download file

Task

VLOOKUP Walkthrough 2

 

 

tick
tick
download file

Task

Class VLOOKUp task

 

  
tick
tick

click here

classxx.xls

Jobs VLOOKUp task

 

  
tick
tick

click here

jobs.xls

Magazines VLOOKUp task

 

  
tick
tick

click here

magazines.xls

click here

magazines answers.xls

Fuel VLOOKUp task

 

  
tick
tick

click here

fuel.xls

click here

fuel answers.xls

Cats VLOOKUp task

 

  
tick
tick

click here

cats.xls

click here

cats answers.xls

Zones VLOOKUp task

 

  
tick
tick

click here

zones lookup.xls

Hogwarts 1 and 2

This spreadsheet exercise provides students with an opportunity to practise:

  • setting up validation (task 1)
  • lookup tables (task 2)

Extension tasks are provided

Contributed by Jon Bridgeman of Finham Park School

 

 
tick
tick

click here

task

 

 

 

 

 

 

 

Copyright © www.teach-ict.com