Spreadsheet: 585459d1533781755-to-retrieve-results-from-referecning-colum-with-duplicates-vlookup-with-dups-and-no-finds
Sheet: Result

Site Code | Location Name | [NAME]
8002 | JET BASE SITE
06031 | Long Term Car Park
02007 | T1 Public Car Park
10029 | C/PARK DMSCP
02T11 | International Terminal, [NAME], Kingsford-Smith Airport, Mascot NSW 2020
02045 | P9 Express pick-up car park
09002 | T3 TERMINAL SITE
03012 | QF International Freight
09001 | T2 SITE AREA.
08040 | [NAME]
08003 | SITE - H.96 & APRON
08012 | DOMESTIC CARGO
05025 | NAP STAFF CAR PARK- NORTH OF CANAL, SWAMP RD, TEMPE
03003 | Full JUHI Site
06037 | Avis Back up
03010 | Express Freighters (QF), [NAME], NW sector
03008 | Toll - Dnata Int'l Freight, Link Rd. NW sector
10086 | SEE 10027 DETAILS - P3 Public Car Park
10078 | TAXI HOLDING AREA
02015 | T1 Taxi Holding
03023 | QF Mail Handling Unit
10060 | BUS & HC PARKING
07090 | Site [NAME]
07060 | [NAME]
03038 | ULD Storage NW
05566 | Yard, Burrows Rd
02143 | Seamless Transfer Site
08032 | MERCEDES APT EXPRESS
07043 | Part [NAME]
05551 | Boral Burrows Rd
06001 | QF Valet car park
06036 | Hertz Backup, SE sector
08030 | QTF ADDITIONAL PARK.
06066 | Service Station
05003 | ACCESSWAY
07076 | [NAME]
07026 | CAR PARK
06072 | McDonalds GHD
07083 | Mantra Hotel
05552 | Boral Burrows Rd
06017 | Budget Back up
07058 | MOTEL SITE
09009 | FREIGHT TOTAL NLA +
05502 | [NAME]
07068 | MCDONALDS GATEWAY
10047 | H3 TOTAL NLA +
09010 | CATERING TOTAL NLA +
02207 | T1 Hotel Site
06038 | Thrifty Back up
06073 | Europcar Back up Facility
02115 | QF ULD / GSE Storage
07018 | CARGO  11ST (previously including 07043)
07075 | [NAME]
07016 | HANGAR F/WING
07093 | Road Reserve Sublease
03024 | QF INTL FREIGHT AWNING
07074 | [NAME]
10048 | CAR PARK - B.246
06080 | Flight Kitchen - SE sector
02029 | T1 QTA for Rental Cars
03040 | ULD Storage NW
07008 | HANGAR F/WING
05570 | Yard, Burrows Rd
04003 | Bureau of Met.
07096 | Road Reserve Sublease
02200 | Site for Customs Building
05554 | Yard, Burrows Rd
05555 | Yard, Burrows Rd
10043 | SITE FOR BUILDING 246
05560 | Yard, Burrows Rd
07015 | HANGAR 13 (Incl. 07055)
7004(A) | AIR AMBULANCE
05564 | Yard, Burrows Rd
07009 | HANGAR F/WING
06525 BE | Site Compound
07039 | STAFF CAR PARK
05501 | Visy B702
02119 | Part [NAME]
07070 | Shared car park
08019 | HANGAR 20 TOTAL
02041 | Central Terrace Building
08005 | Car Park adjacent Gate 1
03005 | [NAME]
07014 | AD ACCESS
03004 | [NAME]
07098 | Site [NAME] - overlaps 07075
05013 | RMS Cycleway - Part
01018 | Barton Park - 07 Middle marker
01032 | CABLE-OPT.FIBRE
01049 | Airside Construction Compound
02016 | CUSTOMS BLDG CARPARK
02028 | CUSTOMS OPS VEHICLES
 | same number with 'B' allocated the same site area here
03002 | Ex PID part of MHU
 | 0
03028 | Small area now Part of MHU
04024 | Site compound in ex SW car park
04027 | [NAME] in ex SW car park
05001 | Total Swamp Rd area (East of HIAL).
05405 | Adshel FSU QF / Apt Drive
05406 | Adshel FSU QF / Apt Drive
05407 | Adshel FSU QF / Apt Drive
05408 | Adshel FSU QF / Apt Drive
05409 | Adshel FSU QF / Apt Drive
05410 | Adshel FSU QF / Apt Drive
05411 | Adshel FSU QF / Apt Drive
05412 | [NAME] Poster
05564A | Yard, Burrows Rd
05583 | Yard, Burrows Rd
06023 | OLD FIRE TRNG GROUND
06042 | Car park area btn 06001 & LTCP
06094 | Vehicle Storage Facility
06561 | RMS Vehicle Inspection Bay
07069 | GATEWAY DEV. SITE
07080 | Part [NAME]
07091 | Site [NAME]
07094 | Road Reserve Sublease
07095 | Road Reserve Sublease
90927 | QF valet parking T3
09028 | QF parking T3
09029 | QF parking T3
09030 | Aero-Care parking
10045 | Building 110
10049 | C/PARK BEHIND B.246
10070 | TAKEAWAY & AMENITIES
11501 | [NAME]
0029RT | B.650 Rooftop aerials - Mobile Phone
AD 02200 | Ad on Customs bldg (B.650)
AD 02401 | Ad Intl DHL Cubes (45001)
AD 02402 | Ad Giovanni Bridge Blade (49101)
AD 02403 | Ad Giovanni Bridge Blade (49001)
AD 02404 | Apt Intl Promo
AD 02405 | Ad Intl Up ramp (44801)
AD 02406 | Ad Intl Cooks Rr Dr. ((44401)
AD 02407 | Ad Intl nr Dock 6 (47901)
AD 02408 | Ad Intl Cooks Rr Dr. (44301)
AD 04401 | Ad SW GHD M5 down ramp (38001/2)
AD 04402 | Ad SW GHD Bridge W'bound (38102)
AD 06 1 | Ad GHD / Mill Pond Rd (37701)
AD 06 2 | Ad Foreshore Rd (37801/2)
AD 06074 | Ad BP Signage
AD 06081 | Ad McDs Signage
AD 06401 | Ad SE GHD E'bound (42301)
AD 06402 | Ad SE GHD W'bound (37901/02))
AD 07 1 | Ad - car park promo - Main Ent.
AD 07 10 | Ad Digital pedestal potrait [NAME]
AD 07 11 | Ad car park promo sth [NAME]
AD 07 2 | Ad Gantry Dom Ent. (43001)
AD 07 3 | Ad Stage Spect. Dom Ent(46801)
AD 07 4 | Ad Reg AN Large - Virgin (43101)
AD 07 5 | Ad adshel FSU Joyce Dr (2008-011)
AD 07 6 | Ad adshel FSU Joyce Dr (2008-012)
AD 07 7 | Ad adshel FSU Joyce Dr (2008-013)
AD 07 8 | Ad adshel FSU Joyce Dr (2008-014)
AD 07 9 | Ad - Ascot lodge south bound
AD 08 1 | Adshel FSU QF Dr. nr Gate 1(2008-009)
AD 08 2 | Adshel FSU QF Dr. nr Gate 1(2008-010)
AD 08 3 | Ad Blades - Robey St.(96501)
AD 08 4 | Ad Blades - Robey St.(96502)
AD 08 5 | Ad cnr 9th & [NAME])
AD 10 1 | Ad LHS start of K.S. Ave (46901)
AD 10 10 | Ad - Shiers Exit LHS (44202)
AD 10 2 | Ad T2/T3 Arrivals (47001)
AD 10 3 | Ad T2/T3 Arrivals (47101)
AD 10 4 | Ad T2/T3 Arrivals (47301)
AD 10 5 | Ad T2/T3 Arrivals (47401)
AD 10 6 | Ad T2/T3 Arrivals (47501)
AD 10 7 | Ad T2/T3 Arrivals (47601)
AD 10 8 | Ad - Shiers under ramp (44101)
AD 10 9 | Ad - Exit gantry Shiers (47802)
N/A | Residue Land MKV (by calculation)
N/A | Residue Land BOT & RKD(by calculation)
05501 + 05502 | Recycling Shed and [NAME]
05551 + 05552 | Materials Handling Yard
06095 BE | Hertz Backup
06096B | Vehicle Storage Facility
06096R | Vehicle Storage Facility
07084 | Part [NAME]
08048 | NE cnr of 8030 off [NAME] Dr
10071 + 128101 | B.128 Site area
7004(B) | AIR AMBULANCE
02009A | New Acft Waste Disposal dump
02200 B | Customs Building - Part Floor Occupancy by Commercial Tenant
02204 | AFP OPS VEHICLES
10030 | 7th St Compound
01045 | [NAME] adj. Northern Ponds
02009 | [NAME]
02024 | Car park under Giovanni Bridge
02032 | SEAMLESS BUS BAY T1
03031 | NW ULD Storage
03032 | NW ULD Storage
03033 | NW ULD Storage
03034 | NW ULD Storage
03035 | NW ULD Storage
04019 | Nominal Site for Roadway in SW Sector
04020 | South West staff car park
07010 | FUEL SITE
07027 | RMS ARTC Compound in ASCOT Lodge
08006 | Ex QF Car Park
10017 | Building 302, Shiers Ave
08004 | HANGAR F/WING
02018 | Construction Compound
06514 | Construction Compound
02017 | Construction Compound
06078 | Carbridge Storage
10027 | P3 Public Car Park
08016 | AIRCRAFT SERV
02004 | Car Rental operators
04005 | Open Ground
06522 | Construction Compounds
10001 | B.309 OFFICE
01010 | 16L GLIDEPATH
08035 | [NAME]
06079 | Hardstand btn Carbridge & Alpha
07062 | ASCOT LODGE
06031 | Long Term Car Park
06031 | Long Term Car Park
03012 | QF International Freight
03012 | Northern part QF Intl Freight
05577 | 11 Canal Rd
06043 | ASA - DVOR
03005 | FUEL PIPELINE
03005 | Fuel Pipeline - part
03005 | Fuel Pipeline - part
03003 | Southern (Main) part JUHI.
03003 | Northern part JUHI
03004 | [NAME] part
03004 | [NAME] part
03004 | Fuel Pipeline - BOT part
05014 | RWY 16R HIAL
01027 | [NAME] pipeline EASEMENT
07097 | 0
03013 | QF Bays 2 and 3.
05591 | Part Rail Corridor
01031 | FIRE TRAINING AREA
04008 | ASA- Air Traffic Services
05027 | Nth sector staff car parking
02005 | T1 Services Building
06521 | Part compound
06519 | Construction Compounds
08045 | Building 420 - AAE Dom Freight
05013 | RTA Cycleway - Part
05013 | RMS Cycleway - Part
05013 | RTA Cycleway - Part
03014 | Primary Gas Main
09007 | QF DTL satellite
01019 | FIRE STATION
05563 | Open Ground, Burrows Rd
06517 | SACL Compound SSE
05012 | Swamp road rail siding land
06525 | Transport Compound
06002 | ASA - Control Tower
02037 | Staff [NAME] of Customs Building, under Apt Dr.
06100 | Airport Storage Yard
07032 | STORMWATER BASIN
04006 | ASA - Car Park
06515 | Construction Compound
07004 | Air ambulance
06018 | ASA - Bldg 170 (ex RSR)
06066 | Service Station
06066 | Service Station
04026 | Open grounds
06062 | Carbridge
01035 | 16L Glidepath
06512 | SACL Compound SSE
05579 | Yard, Burrows Rd
01004 | ASA - 07 Glidepath
06503 | COMPOUND
03011 | [NAME].
06014 | ASA TA Radar
06052 | Additional car rental storage
07033 | SACL Water Tanks
06061 | NURSERY
07092 | Site [NAME]
06083 | Hardstand btn Carbridge & Alpha
04009 | ASA - No. 2 Fire Station
05561 | Yard, Burrows Rd
06082 | Hardstand btn Carbridge & Alpha
05016 | DeSalination Pipeline in  16R HIAL
06053 | Vehicle storage yard
06516 | SACL Compound SSE
03029 | QF Link Rd car park (Part of [NAME])
03029 | QF Link Rd car park
03029 | QF Car Park - LAND TAX
06046 | BC Sands
01012 | 34R GLIDEPATH
02010 | T1 Cooling Towers
06504 | COMPOUND
06505 | Construction Compounds
06508 | Construction Compounds
05576 | Yard, Burrows Rd
05565 | Yard, Burrows Rd
09012 | CARGO APRON
05019 | Alexandra Canal Bridge Rights - Northern.
07031 | SACL Pollution Separators
01029 | ASA ARFF Staff Car Park
06095 | Vehicle storage SE sector
01006 | 16R GLIDEPATH
05567 | Yard, Burrows Rd
04007 | Works Compound opp ATS centre
05557 | Yard, Burrows Rd
01009 | 34L localiser
06063 | Dumpex yard
06097 | Yard SE sector
07041 | (DOM4) - OFFICE
01036 | RWY 25 G'PATH
04032 | [NAME]. Storage
07005 | B458 [NAME]
06071 | PARK & BARK
07023 | CAR PARK
06067 | Storage yard
03027 | Livestock Transfer Facility
07072 | airside hangar area
05018 | Alexandra Canal Bridge Rights - Southern.
07056 | [NAME]
07035 | PORTABLE OFFICE & CA
01008 | 34L GLIDEPATH
08011 | ADMIN OFFICE
03025 | QF Car park adj. [NAME]
06024 | ASA - Precision RWY Monitor
08038 | [NAME]
02022 | Water Recycling facility
07066 | [NAME]
06045 | Now part of 06017 - Budget
04021 | Works compound
08022 | AIRPORT Water Tanks
03026 | QF Car park adj. MHU
07028 | [NAME]
08046 | Airside GSE adj. Gate 1
05020 | Site for rail crossing
07082 | 11th St car park adj 273
06506 | Construction Compounds
06509 | Part compound
06510 | Construction Compounds
06511 | Construction Compounds
06520 | Construction Compounds
06520 | #N/A
06520 | Storage Yard, [NAME], Mascot NSW 2020
01005 | 07 LOCALISER
10052 | B.108 WORKSHOP
07055 | LICENCE AREA
02120 | DeSalination pipeline on Golf course
07065 | FREIGHT ACCESS ROAD
02044 | New car park adjacent Customs Building
01034 | MET. WIND PROFILER
03036 | [NAME] adj Toll
06004 | HANGAR ROTARY
05553 | Yard, Burrows Rd
02035 | Storage Yard adj QF Seamless
07071 | BUILDING 273 +
02042 | ACCESSWAY
06091 | 0
07077 | Airside GSE storage 11th St
07081 | A/S area adj 07077
08034 | FUEL PIPELINE
10075 | TAXI CAR WASH
05582 | Yard, Burrows Rd
05581 | Yard, Burrows Rd
02039 | T1 Limousine Parking Area
05569 | Yard, Burrows Rd
09008 | QF DTL AEROBRIDGES
07079 | Gateway Landscape
06035 | HANGAR ROTARY
08049 | Qantas domestic freight
06092 | 0
08014 | C/PARK STAFF
02034 | SEAMLESS BUS ACCESS  - Qantas
09017 | QF DTL AEROBRIDGES
05004 | OVERHEAD ROAD
06513 | Construction Compound
07057 | (DOM4) - W'HOUSE
01013 | 34R LOCALISER
06009 | HANGAR ROTARY
03043 | Car Parking Link Rd
08050 | Qantas domestic freight
01011 | 16L LOCALISER
02124 | GSE/ULD storage South of QST.
08031 | ACCESSWAY
08028 | ACCESSWAY
10071 | plus 128101 - Domestic taxi holding café
09022 | AIRSIDE VEHICLE PARKING
03039 | QF Link Rd parking
02014 | 1 Old St. Tempe Water Tower
07073 | LANDSCAPE VERGE
10050 | B112 Vickers Ave
10041 | B.111 WAREHOUSE
06090 | HELIPAD - VNE
10055 | Above ground hydrant line
06012 | HELI TOTAL NLA
06093 | 0
06006 | HANGAR ROTARY (H.451)
02036 | SEAMLESS BUS STOP  - Qantas
02033 | Walkway btn T1 and QF Seamless
06011 | ADMIN OFFICE
10073 | PARKING 6TH ST
06087 | Additional Car park adjacent Park & Bark.
10062 | B112 Licence Area
01023 | OPS-AIRSERVICES
01024 | OPS-AIRSERVICES
01026 | OPS-AIRSERVICES
04012 | ASA - Anemometer No. 1
06025 | ANENOMETER NO. 2
01007 | 16R LOCALISER
08041 | CANOPY
01015 | RVR TRANSMISSOMETER
01016 | RVR TRANSMISSOMETER
01017 | RVR TRANSMISSOMETER
10080 | C/PARK-7TH ST COMP
10040 | B.521 TOTAL NLA +
08024 | SUBSTATION
01037 | ASA - 25 LLZ
05578 | Open Ground, Burrows Rd
03042 | Link Road Staff Car Park
02023 | T1 Unigas
10069 | OFFICE TOTAL NLA
08039 | CAR PARK
03030 | [NAME] adj Toll - CAR PARK
08021 | AIRPORT Substation
02210 | Site Compound
03006 | [NAME]
01033 | Bur. of Meteorology - Visibility Meter
08029 | MOBILE PHONE TOWER
01039 | B.431 - EMERGENCY HUT
01047 | [NAME] adj Northern Ponds
01038 | ASA - 25 LLZ Bldg
08027 | Cable Hut
10077 | B.419 STORAGE SPACE
10079 | C/PARK- 7TH ST
02205 | T1 KERBSIDE MANAGEMENT OFFICE
05017 | Adj. Rail & Goods yard - NW of rail corridor.
02211 | Site Compound
02212 | Site Compound
01002 | MARINE NAVAID (34L structure)
10088 | Live Group partnership
02047 | small site at arrivals court.
01050 | Waste Compactor
02213 | Site Compound
05404 | Large [NAME] (219101)
06032 | BUILDING 470
02214 | Site Compound
05401 | Ad Airport Dr. (3 Sisters)
05402 | Ad Airport Dr. (3 Sisters)
05403 | Ad Airport Dr. (3 Sisters)
01028 | MARINE NAVAID (34R equip.)
10081 | C/PARK - 7TH ST
10085 | [NAME]
10089 | Live Group partnership
06081 | McDonalds
01040 | MARINE NAVAID