Spreadsheet: 101432d1299560602-regarding-conditional-if-statement-querry-1-
Sheet: Sheet1

Assume other than R1Z as non residential for simplicity. Ignore Category "Other"
I need the same order of description as it has been associated with individual parcels in ARCGIS with object IDs
There are only Two Categories of Residential R1Z and R2Z for which I need to find individual cell and put it as "Residential"
DESCRIPT0N | Classification
PUZ3 - Public Use - Health Community | [NAME]
PUZ7 - Public Use - Other Public Use | [NAME]
PPRZ - Public Park & Recreation | [NAME]
PUZ1 - Public Use - Service & Utility
PUZ4 - Public Use - Transport
[NAME] | Residential
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
IN1Z - Industrial 1
PUZ3 - Public Use - Health Community
[NAME] Use 2
PPRZ - Public Park & Recreation
PUZ4 - Public Use - Transport
B2Z - Business 2
PUZ4 - Public Use - Transport
SUZ1 - Special Use 1
PUZ5 - Public Use - Cemetery/Crematorium
[NAME]
MUZ - Mixed Use
CDZ1 - Comprehensive Development
PUZ1 - Public Use - Service & Utility
[NAME]
B1Z - Business 1
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
[NAME]
[NAME]
PPRZ - Public Park & Recreation
PUZ6 - Public Use - Local Government
[NAME]
MUZ - Mixed Use
B1Z - Business 1
PUZ2 - Public Use - Education
[NAME]
PUZ1 - Public Use - Service & Utility
IN3Z - Industrial 3
B3Z - Business 3
PUZ1 - Public Use - Service & Utility
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
MUZ - Mixed Use
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
IN3Z - Industrial 3
PUZ2 - Public Use - Education
B1Z - Business 1
[NAME]
IN1Z - Industrial 1
PUZ2 - Public Use - Education
PUZ3 - Public Use - Health Community
PPRZ - Public Park & Recreation
MUZ - Mixed Use
[NAME]
B1Z - Business 1
[NAME]
PPRZ - Public Park & Recreation
PUZ6 - Public Use - Local Government
[NAME]
IN1Z - Industrial 1
PUZ1 - Public Use - Service & Utility
B3Z - Business 3
PUZ1 - Public Use - Service & Utility
PUZ1 - Public Use - Service & Utility
IN1Z - Industrial 1
PPRZ - Public Park & Recreation
MUZ - Mixed Use
IN1Z - Industrial 1
PPRZ - Public Park & Recreation
MUZ - Mixed Use
PPRZ - Public Park & Recreation
IN1Z - Industrial 1
PUZ2 - Public Use - Education
PPRZ - Public Park & Recreation
MUZ - Mixed Use
PPRZ - Public Park & Recreation
PUZ7 - Public Use - Other Public Use
[NAME]
PUZ2 - Public Use - Education
MUZ - Mixed Use
[NAME]
CDZ2 - Comprehensive Development
PUZ4 - Public Use - Transport
PUZ7 - Public Use - Other Public Use
MUZ - Mixed Use
[NAME]
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
MUZ - Mixed Use
[NAME]
PPRZ - Public Park & Recreation
MUZ - Mixed Use
PPRZ - Public Park & Recreation
MUZ - Mixed Use
PUZ3 - Public Use - Health Community
MUZ - Mixed Use
MUZ - Mixed Use
MUZ - Mixed Use
PPRZ - Public Park & Recreation
PUZ3 - Public Use - Health Community
[NAME] | Residential
PUZ3 - Public Use - Health Community
[NAME]
PPRZ - Public Park & Recreation
PUZ2 - Public Use - Education
MUZ - Mixed Use
MUZ - Mixed Use
B2Z - Business 2
PPRZ - Public Park & Recreation
PUZ3 - Public Use - Health Community
B2Z - Business 2
PPRZ - Public Park & Recreation
B2Z - Business 2
SUZ3 - Special Use 3
MUZ - Mixed Use
[NAME]
PUZ3 - Public Use - Health Community
PPRZ - Public Park & Recreation
PUZ3 - Public Use - Health Community
PPRZ - Public Park & Recreation
MUZ - Mixed Use
PUZ7 - Public Use - Other Public Use
CCZ2 - Capital City
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
MUZ - Mixed Use
PUZ3 - Public Use - Health Community
PUZ7 - Public Use - Other Public Use
CA - Commonwealth Land (not in scheme)
PUZ3 - Public Use - Health Community
CCZ1 - Capital City
PPRZ - Public Park & Recreation
RDZ2 - Road - Category 2
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
B1Z - Business 1
PUZ4 - Public Use - Transport
MUZ - Mixed Use
PPRZ - Public Park & Recreation
PUZ4 - Public Use - Transport
PUZ4 - Public Use - Transport
[NAME]
PPRZ - Public Park & Recreation
PUZ4 - Public Use - Transport
PUZ4 - Public Use - Transport
[NAME]
B5Z - Business 5
B5Z - Business 5
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
[NAME]
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
RDZ2 - Road - Category 2
CCZ1 - Capital City
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
CCZ1 - Capital City
[NAME]
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
MUZ - Mixed Use
PPRZ - Public Park & Recreation
CCZ1 - Capital City
PUZ4 - Public Use - Transport
PUZ4 - Public Use - Transport
MUZ - Mixed Use
CCZ1 - Capital City
PUZ2 - Public Use - Education
PUZ3 - Public Use - Health Community
MUZ - Mixed Use
[NAME]
[NAME]
[NAME]
PPRZ - Public Park & Recreation
[NAME]
[NAME]
[NAME]
RDZ1 - Road - Category 1
RDZ1 - Road - Category 1
PUZ3 - Public Use - Health Community
PPRZ - Public Park & Recreation
IN1Z - Industrial 1
DZ5 - Dockland
DZ4 - Dockland
DZ3 - Dockland
DZ3 - Dockland
SUZ4 - Special Use 4
SUZ5 - Special Use 5
DZ6 - Dockland
DZ7 - Dockland
IN3Z - Industrial 3
PUZ2 - Public Use - Education
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
IN3Z - Industrial 3
B2Z - Business 2
B2Z - Business 2
B1Z - Business 1
PPRZ - Public Park & Recreation
PUZ6 - Public Use - Local Government
IN1Z - Industrial 1
[NAME]
B1Z - Business 1
PUZ4 - Public Use - Transport
[NAME]
RDZ1 - Road - Category 1
RDZ1 - Road - Category 1
B1Z - Business 1
MUZ - Mixed Use
[NAME]
PPRZ - Public Park & Recreation
PPRZ - Public Park & Recreation
CCZ1 - Capital City
PPRZ - Public Park & Recreation
DZ3 - Dockland
DZ2 - Dockland
B2Z - Business 2
IN1Z - Industrial 1