Spreadsheet: 120328d1315215799-vlookup-to-lookup-an-un-named-column-tfl-prices
Sheet: Sheet1

Zone | Zonal Coverage |  | Cash | Oyster pay as you go |  |  |  | Travelcards
 | From Zone | To Zone |  | Peak single | Off-peak single | Peak price cap | Off-peak price cap | Day Anytime | Day Off-peak | 7 Day | Monthly | Annual
Zone 1
Zone 1 only | 1 | 1 | 4 | 1.9 | 1.9 | 8 | 6.6 | 8 | 6.6 | 27.6 | 106 | 1104
Zones 1-2 | 1 |  | 4 | 2.5 | 1.9 | 8 | 6.6 | 8 | 6.6 | 27.6 | 106 | 1104
[NAME] | 1 | 2 | 4 | 2 | 1.9 | 8 | 6.6 | 8 | 6.6 | 27.6 | 106 | 1104
Zones 1-3 | 1 |  | 4 | 2.9 | 2.5 | 10 | 7.3 | 10 | 7.3 | 32.2 | 123.7 | 1288
[NAME] 3* | 1 | 3 | 4 | 2.7 | 2.5 | 10 | 7.3 | 10 | 7.3 | 32.2 | 123.7 | 1288
Zones 1-4 | 1 | 4 | 5 | 3.4 | 2.5 | 10 | 7.3 | 10 | 7.3 | 39.4 | 151.3 | 1576
[NAME] | 1 | 4 | 5 | 3.1 | 2.5 | 10 | 7.3 | 10 | 7.3 | 39.4 | 151.3 | 1576
Zones 1-5 | 1 | 5 | 5 | 4.1 | 2.7 | 15 | 8 | 15 | 8 | 47 | 180.5 | 1880
[NAME] | 1 | 5 | 5 | 3.8 | 2.7 | 15 | 8 | 15 | 8 | 47 | 180.5 | 1880
Zones 1-6 | 1 | 6 | 5 | 4.5 | 2.7 | 15 | 8 | 15 | 8 | 50.4 | 193.6 | 2016
[NAME] 6* | 1 | 6 | 5 | 4.2 | 2.7 | 15 | 8 | 15 | 8 | 50.4 | 193.6 | 2016
Zones 1-7 | 1 | 7 | 6 | 5 | 3.5 | 18.6 | 11 | 18.6 | 11 | 54.8 | 210.5 | 2192
[NAME] 7* | 1 | 7 | 6 | 4.5 | 3.5 | 18.6 | 11 | 18.6 | 11 | 54.8 | 210.5 | 2192
Zones 1-8 | 1 | 8 | 7 | 6 | 3.5 | 18.6 | 11 | 18.6 | 11 | 64.6 | 248.1 | 2584
[NAME] 8* | 1 | 8 | 7 | 5.5 | 3.5 | 18.6 | 11 | 18.6 | 11 | 64.6 | 248.1 | 2584
Zones 1-9 | 1 | 9 | 7 | 6 | 3.5 | 18.6 | 11 | 18.6 | 11 | 71.6 | 275 | 2864
Zones 1-9 + Watford Junction | 1 | 9 Inc Watford | £12.30** | 7.7 | 5 | 19 | 14.5 | 19 | 14.5 | 71.7 | 275.4 | 2868
Zones 1-9 + Grays | 1 | 9 Inc Greys | - | 6.9 | 5.9 | 19 | 14.5 | - | - | - | - | -
Euston - Watford Junction* | [NAME] | Watford | 8.3 | 6.9 | 4.1 | 19 | 14.5 | 19 | 14.5 | 71.7 | 275.4 | 2868
Zone 2
Zone 2 only | 2 | 2 | 4 | 1.4 | 1.3 | 8 | 6.6 | 8 | 6.6 | 20.8 | 79.9 | 832
Zones 2-3 | 2 | 3 | 4 | 1.4 | 1.3 | 10 | 7.3 | 10 | 7.3 | 20.8 | 79.9 | 832
Zones 2-4 | 2 | 4 | 4 | 2.2 | 1.4 | 10 | 7.3 | 10 | 7.3 | 22.8 | 87.6 | 912
Zones 2-5 | 2 | 5 | 5 | 2.5 | 1.4 | 15 | 8 | 15 | 8 | 27.4 | 105.3 | 1096
Zones 2-6 | 2 | 6 | 5 | 2.5 | 1.4 | 15 | 8 | 15 | 8 | 34.4 | 132.1 | 1376
Zones 2-7 | 2 | 7 | 5 | 3.5 | 2.5 | 18.6 | 11 | 18.6 | 11 | 35.6 | 136.8 | 1424
Zones 2-8 | 2 | 8 | 6 | 4 | 2.5 | 18.6 | 11 | 18.6 | 11 | 48.6 | 186.7 | 1944
Zones 2-9 | 2 | 9 | 6 | 4 | 2.5 | 18.6 | 11 | 18.6 | 11 | 48.6 | 186.7 | 1944
Zones 2-9 + Watford Junction | 2 | 9 Inc Watford | 6 | 4 | 2.5 | 19 | 14.5 | 19 | 14.5 | 48.6 | 186.7 | 1944
Zones 2-9 + Grays | 2 | 9 Inc Greys | - | 4.3 | 3.5 | 19 | 14.5 | - | - | - | - | -
Zone 3
Zone 3 only | 3 | 3 | 4 | 1.4 | 1.3 | 10 | 7.3 | 10 | 7.3 | 20.8 | 79.9 | 832
Zones 3-4 | 3 | 4 | 4 | 1.4 | 1.3 | 10 | 7.3 | 10 | 7.3 | 20.8 | 79.9 | 832
Zones 3-5 | 3 | 5 | 4 | 2.2 | 1.4 | 15 | 8 | 15 | 8 | 22.8 | 87.6 | 912
Zones 3-6 | 3 | 6 | 5 | 2.5 | 1.4 | 15 | 8 | 15 | 8 | 27.4 | 105.3 | 1096
Zones 3-7 | 3 | 7 | 5 | 3 | 1.4 | 18.6 | 11 | 18.6 | 11 | 35.6 | 136.8 | 1424
Zones 3-8 | 3 | 8 | 5 | 3.5 | 1.4 | 18.6 | 11 | 18.6 | 11 | 48.6 | 186.7 | 1944
Zones 3-9 | 3 | 9 | 5 | 3.5 | 1.4 | 18.6 | 11 | 18.6 | 11 | 48.6 | 186.7 | 1944
Zones 3-9 + Watford Junction | 3 | 9 Inc Watford | 5 | 3.5 | 1.4 | 19 | 14.5 | 19 | 14.5 | 48.6 | 186.7 | 1944
Zones 3-9 + Grays | 3 | 9 Inc Greys | - | 4 | 3.4 | 19 | 14.5 | - | - | - | - | -
Zone 4
Zone 4 only | 4 | 4 | 4 | 1.4 | 1.3 | 10 | 7.3 | 10 | 7.3 | 20.8 | 79.9 | 832
Zones 4-5 | 4 | 5 | 4 | 1.4 | 1.3 | 15 | 8 | 15 | 8 | 20.8 | 79.9 | 832
Zones 4-6 | 4 | 6 | 4 | 2.2 | 1.4 | 15 | 8 | 15 | 8 | 22.8 | 87.6 | 912
Zones 4-7 | 4 | 7 | 4 | 2.5 | 1.4 | 18.6 | 11 | 18.6 | 11 | 25.8 | 99.1 | 1032
Zones 4-8 | 4 | 8 | 5 | 3 | 1.4 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zones 4-9 | 4 | 9 | 5 | 3 | 1.4 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zones 4-9 + Watford Junction | 4 | 9 Inc Watford | 5 | 3 | 1.4 | 19 | 14.5 | 19 | 14.5 | 43.4 | 166.7 | 1736
Zones 4-9 + Grays | 4 | 9 Inc Greys | - | 3.5 | 2.6 | 19 | 14.5 | - | - | - | - | -
Zone 5
Zone 5 only | 5 | 5 | 4 | 1.4 | 1.3 | 15 | 8 | 15 | 8 | 20.8 | 79.9 | 832
Zones 5-6 | 5 | 6 | 4 | 1.4 | 1.3 | 15 | 8 | 15 | 8 | 20.8 | 79.9 | 832
Zones 5-7 | 5 | 7 | 4 | 2 | 1.4 | 18.6 | 11 | 18.6 | 11 | 25.8 | 99.1 | 1032
Zones 5-8 | 5 | 8 | 4 | 2.5 | 1.4 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zones 5-9 | 5 | 9 | 4 | 2.5 | 1.4 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zones 5-9 + Watford Junction | 5 | 9 Inc Watford | 4 | 2.5 | 1.4 | 19 | 14.5 | 19 | 14.5 | 43.4 | 166.7 | 1736
Zones 5-9 + Grays | 5 | 9 Inc Greys | - | 2.3 | 2 | 19 | 14.5 | - | - | - | - | -
Zone 6
Zone 6 only | 6 | 6 | 4 | 1.4 | 1.3 | 15 | 8 | 15 | 8 | 20.8 | 79.9 | 832
Zones 6-7 | 6 | 7 | 4 | 1.4 | 1.3 | 18.6 | 11 | 18.6 | 11 | 25.8 | 99.1 | 1032
Zones 6-8 | 6 | 8 | 4 | 2 | 1.3 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zones 6-9 | 6 | 9 | 4 | 2 | 1.4 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zones 6-9 + Watford Junction* | 6 | 9 Inc Watford | 4 | 2 | 1.4 | 19 | 14.5 | 19 | 14.5 | 43.4 | 166.7 | 1736
Zones 6-9 + Grays | 6 | 9 Inc Greys | - | 2.3 | 2 | 19 | 14.5 | - | - | - | - | -
Zone 7
Zone 7 only | 7 | 7 | 4 | 1.4 | 1.3 | 18.6 | 11 | 18.6 | 11 | 25.8 | 99.1 | 1032
Zones 7-8 | 7 | 8 | 4 | 1.4 | 1.3 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zones 7-9 | 7 | 9 | 4 | 1.5 | 1.3 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zones 7-9 + Watford Junction* | 7 | 9 Inc Watford | - | 1.5 | 1.3 | 19 | 14.5 | 19 | 14.5 | 43.4 | 166.7 | 1736
Zone 8
Zone 8 only* | 8 | 8 | - | 1.4 | 1.3 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zones 8-9 | 8 | 9 | 4 | 1.4 | 1.3 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zone 9 | 9 | 9 | - | 1.4 | 1.3 | 18.6 | 11 | 18.6 | 11 | 43.4 | 166.7 | 1736
Zone 8 +s Watford Junction* | 8 | Watford | 2.5 | 1.4 | 1.3 | 19 | 14.5 | 19 | 14.5 | 43.4 | 166.7 | 1736