Excel 2007: VLOOKUP

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

Resource

KS3

KS4

KS5

Click Here

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

 

 

 

 

 

 

 

Copyright © www.teach-ict.com