Spreadsheet: 214871d1361169058-non-vba-3-way-look-up-on-3-arrays-sample
Sheet: Availability

Y | YES
N | NO |  |  |  | [NAME]
M | MAYBE
B | BOOKED
 |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday |  |  | Campus/s
First name | Last Name | MAM | MPM | MEVE | TAM | TPM | TEVE | WAM | WPM | WEVE | THAM | THPM | THEVE | FAM | FPM | FEVE | SAM | SPM | SEVE | SNAM | SNPM | SNEVE | Croydon | Lilydale | Wantirna | Hawthorn | Prahran
[NAME] | Conway | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
Anna | Haines
[NAME] | [NAME]
Carole | [NAME] | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | M | M | N | M | M | N | Y | Y | Y | N | N
[NAME] | Simpson | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
Danielle | Coombes | N | N | N | B | B | N | B | N | N | B | N | N | Y | Y | N | N | N | N | N | N | N | Y | Y | Y | N | N
Danielle | [NAME] | Y | Y | M | Y | Y | M | B | B | M | B | B | N | B | B | M | M | M | N | M | M | N | Y | Y | Y | N | N
Daryl | Costin | Y | Y | B | Y | Y | B | Y | Y | B | Y | Y | B | Y | Y | B | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | N
Debbie | Yule | N | N | N | N | N | N | N | Y | N | B | B | Y | Y | Y | N | N | N | N | N | N | N | Y | Y | Y | N | N
[NAME] | [NAME] | Y | N | N | B | B | N | N | N | N | Y | Y | N | B | N | N | N | N | N | N | N | N | Y | N | Y | N | N
[NAME] | Marnik
Frances | Pike | Y | M | Y | Y | M | Y | Y | M | Y | Y | M | Y | Y | M | N | N | Y | Y | Y | Y | Y | Y | N | Y | Y | N
Gay | Thambia | B | B | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | N | N | N | N | N | Y | N | Y | N | N
[NAME] | Hall | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | N | N | M | N | N | Y | Y | N | Y | Y | Y
Graeme | Sutton | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | Y | Y | Y | Y | Y | Y | N | N | N | N | N
[NAME] | [NAME] | B | N | N | N | N | N | N | N | N | N | B | N | B | B | N | N | N | N | N | N | N | Y | N | Y | N | N
Helen | Ogilvie
[NAME] | [NAME] | B | Y | Y | B | B | Y | B | B | Y | B | B | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y
[NAME] | Swart | B | N | N | B | N | N | B | N | N | B | B | N | B | N | N | N | N | N | N | N | N | Y | N | N | Y | N
Janice | Ferrari | N | Y | N | Y | Y | N | Y | N | N | Y | B | N | N | N | N | N | N | N | N | N | N | Y | N | Y | N | N
Janice | Keanen | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N
[NAME] | Johns
[NAME] | [NAME] | Y | Y | N | Y | Y | N | Y | Y | N | Y | Y | N | Y | Y | N | N | Y | N | Y | Y | N | Y | Y | Y | N | N
Julianne | Morman | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | Y | Y | N | N | N | N | Y | Y | Y | M | N
Kathy | [NAME] | Y | Y | N | Y | B | N | Y | Y | N | Y | N | N | B | B | N | N | N | N | N | N | N | Y | Y | Y | N | N
Kerrie | Beveridge | Y | B | N | M | M | N | B | Y | N | N | N | N | B | B | N | N | N | N | N | N | N | Y | Y | Y | Y | N
[NAME] | Sadler | N | N | N | N | N | N | Y | Y | N | Y | Y | N | B | N | N | N | N | N | N | N | N | Y | N | Y | N | N
[NAME] | [NAME] | n | N | N | Y | Y | Y | N | N | N | N | N | Y | Y | Y | Y | N | N | N | N | N | N | Y | Y | Y | N | N
Laurel | Hertan | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | N | M | N | N | N | N | Y | Y | Y | N | N
[NAME] | [NAME] | Y | N | Y | Y | Y | Y | N | N | Y | N | N | N | N | N | Y | Y | Y | N | N | N | N | Y | Y | Y | N | N
[NAME] | Morrison | N | Y | Y | Y | Y | Y | Y | Y | Y | B | B | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | N | N
[NAME] | [NAME] | Y | Y | N | Y | B | N | Y | Y | N | B | Y | N | Y | M | N | N | N | N | N | N | N | Y | N | Y | N | N
Margo | Jennings | Y | N | N | Y | Y | N | B | N | N | Y | N | N | B | B | N | N | N | N | N | N | N | Y | Y | Y | N | N
[NAME] | Hartland | Y | Y | N | Y | Y | N | Y | Y | N | Y | Y | N | Y | Y | N | N | N | N | N | N | N | Y | Y | N | N | N
[NAME] | Davey | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | N | N | N |  |  |  | Y | Y | Y
Michelle | Urbanic | Y | Y | Y | Y | Y | Y | B | B | Y | B | B | Y | Y | Y | M | N | N | N | N | N | N | Y | N | Y | N | N
[NAME] | Ullrich
Monika | Senior | B | B | Y | B | B | Y | Y | Y | N | N | B | N | B | Y | Y | Y | Y | N | N | N | N | Y | Y | Y | N | N
[NAME] | Dennis | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | Y | N | Y | N | N
Phoebe | Jaebsch
Pieter | [NAME]
Rebekha | Mitchell | m | m | N | m | m | n | m | m | n | m | m | n | m | m | n | N | N | N | N | N | N | Y | Y | Y | N | N
[NAME] | Sutton | Y | Y | Y | N | N | N | B | Y | Y | Y | B | Y | B | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | N
[NAME] | [NAME] (Anker) | Y | Y | N | B | Y | N | B | B | N | B | N | N | B | Y | N | N | N | Y | N | N | Y | Y | Y | N | Y | Y
Sandra | Pollard | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | N | N | N | N | N | Y | Y | Y | Y | Y
[NAME] | Lewis | N | N | N | B | B | N | B | B | N | B | B | N | N | N | N | N | N | N | N | N | N | Y | N | N | N | N
[NAME] | Simpson
[NAME] | Pao | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | N | N | N | N | N | N | Y | Y | Y | Y | N
Sue | [NAME] | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | N | N | N | N | N | N | Y | Y | N | N | N
[NAME] | [NAME] | B | Y | N | Y | Y | N | M | M | N | B | M | N | B | B | N | N | N | N | N | N | N | Y | Y | Y | N | N
[NAME] | Hanson
[NAME] | Pheobe
Will | Humphrys | Y | Y | N | Y | Y | N | Y | B | N | Y | Y | N | Y | B | N | N | N | N | N | N | N | Y | Y | Y | N | N
Yvonne | Potter | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | Not to be used
 |  | 2012-01-30 00:00:00
[NAME] | Conway
Anna | Haines
[NAME] | [NAME]
Carole | [NAME]
[NAME] | Simpson
Danielle | Coombes
Danielle | [NAME]
Daryl | Costin
Debbie | Yule
[NAME] | [NAME]
[NAME] | Marnik
Frances | Pike
Gay | Thambia
[NAME] | Hall
Graeme | Sutton
[NAME] | [NAME]
Helen | Ogilvie
[NAME] | [NAME]
[NAME] | Swart
Janice | Ferrari
Janice | Keanen
[NAME] | Johns
[NAME] | [NAME]
Julianne | Morman
Kathy | [NAME]
Kerrie | Beveridge
[NAME] | Sadler
[NAME] | [NAME]
Laurel | Hertan
[NAME] | [NAME]
[NAME] | Morrison
[NAME] | [NAME]
Margo | Jennings
[NAME] | Hartland
[NAME] | Davey
Michelle | Urbanic
[NAME] | Ullrich
Monika | Senior
[NAME] | Dennis
Phoebe | Jaebsch
Pieter | [NAME]
Rebekha | Mitchell
[NAME] | Sutton
[NAME] | [NAME] (Anker)
Sandra | Pollard
[NAME] | Lewis
[NAME] | Simpson
[NAME] | Pao
Sue | [NAME]
[NAME] | [NAME]
[NAME] | Hanson
[NAME] | Pheobe
Will | Humphrys
Yvonne | Potter
am |  | 2012-01-30 00:00:00
[NAME] | Conway
Anna | Haines
[NAME] | [NAME]
Carole | [NAME]
[NAME] | Simpson
Danielle | Coombes
Danielle | [NAME]
Daryl | Costin
Debbie | Yule
[NAME] | [NAME]
[NAME] | Marnik
Frances | Pike
Gay | Thambia
[NAME] | Hall
Graeme | Sutton
[NAME] | [NAME]
Helen | Ogilvie
[NAME] | [NAME]
[NAME] | Swart
Janice | Ferrari
Janice | Keanen
[NAME] | Johns
[NAME] | [NAME]
Julianne | Morman
Kathy | [NAME]
Kerrie | Beveridge
[NAME] | Sadler
[NAME] | [NAME]
Laurel | Hertan
[NAME] | [NAME]
[NAME] | Morrison
[NAME] | [NAME]
Margo | Jennings
[NAME] | Hartland
[NAME] | Davey
Michelle | Urbanic
[NAME] | Ullrich
Monika | Senior
[NAME] | Dennis
Phoebe | Jaebsch
Pieter | [NAME]
Rebekha | Mitchell
[NAME] | Sutton
[NAME] | [NAME] (Anker)
Sandra | Pollard
[NAME] | Lewis
[NAME] | Simpson
[NAME] | Pao
Sue | [NAME]
[NAME] | [NAME]
[NAME] | Hanson
[NAME] | Pheobe
Will | Humphrys
Yvonne | Potter
pm |  | 2012-01-30 00:00:00
[NAME] | Conway
Anna | Haines
[NAME] | [NAME]
Carole | [NAME]
[NAME] | Simpson
Danielle | Coombes
Danielle | [NAME]
Daryl | Costin
Debbie | Yule
[NAME] | [NAME]
[NAME] | Marnik
Frances | Pike
Gay | Thambia
[NAME] | Hall
Graeme | Sutton
[NAME] | [NAME]
Helen | Ogilvie
[NAME] | [NAME]
[NAME] | Swart
Janice | Ferrari
Janice | Keanen
[NAME] | Johns
[NAME] | [NAME]
Julianne | Morman
Kathy | [NAME]
Kerrie | Beveridge
[NAME] | Sadler
[NAME] | [NAME]
Laurel | Hertan
[NAME] | [NAME]
[NAME] | Morrison
[NAME] | [NAME]
Margo | Jennings
[NAME] | Hartland
[NAME] | Davey
Michelle | Urbanic
[NAME] | Ullrich
Monika | Senior
[NAME] | Dennis
Phoebe | Jaebsch
Pieter | [NAME]
Rebekha | Mitchell
[NAME] | Sutton
[NAME] | [NAME] (Anker)
Sandra | Pollard
[NAME] | Lewis
[NAME] | Simpson
[NAME] | Pao
Sue | [NAME]
[NAME] | [NAME]
[NAME] | Hanson
[NAME] | Pheobe
Will | Humphrys
Yvonne | Potter
all day |  | 2012-01-30 00:00:00
[NAME] | Conway
Anna | Haines
[NAME] | [NAME]
Carole | [NAME]
[NAME] | Simpson
Danielle | Coombes
Danielle | [NAME]
Daryl | Costin
Debbie | Yule
[NAME] | [NAME]
[NAME] | Marnik
Frances | Pike
Gay | Thambia
[NAME] | Hall
Graeme | Sutton
[NAME] | [NAME]
Helen | Ogilvie
[NAME] | [NAME]
[NAME] | Swart
Janice | Ferrari
Janice | Keanen
[NAME] | Johns
[NAME] | [NAME]
Julianne | Morman
Kathy | [NAME]
Kerrie | Beveridge
[NAME] | Sadler
[NAME] | [NAME]
Laurel | Hertan
[NAME] | [NAME]
[NAME] | Morrison
[NAME] | [NAME]
Margo | Jennings
[NAME] | Hartland
[NAME] | Davey
Michelle | Urbanic
[NAME] | Ullrich
Monika | Senior
[NAME] | Dennis
Phoebe | Jaebsch
Pieter | [NAME]
Rebekha | Mitchell
[NAME] | Sutton
[NAME] | [NAME] (Anker)
Sandra | Pollard
[NAME] | Lewis
[NAME] | Simpson
[NAME] | Pao
Sue | [NAME]
[NAME] | [NAME]
[NAME] | Hanson
[NAME] | Pheobe
Will | Humphrys
Yvonne | Potter