SYLLABUS
- considerations for the construction and design of lookup tables in spreadsheets 11 ATAR
VOCABULARY
- design = how a spreadsheet appears.
- vlookup = look up a vertical column to find the information needed.
- hlookup = look along a row to find the information needed.
DETAILS for VLOOKUP
copy from here if you wish...
| 1 | Student Number | Form | Student | Roll | Student No: | S125 | |
| 2 | S123 | 11F1 | Bill | Current | First Name: | Mary | |
| 3 | S124 | 11H1 | Robert | Former | |||
| 4 | S125 | 11O1 | Mary | Current |
FOR YOU TO DO
- Make an excel spreadsheet which uses vlookup. Copy the data above or make up your own.
Learn more from Good One Here, computer hope and excel for dummies
Found an error or enhancement? Please fill out this contact us form.