Spreadsheet: 877338d1724143772-formula-to-return-value-from-list-if-text-is-matched-workbook2-test-20th-aug-24
Sheet: PO CON

CONSTRUCTION  PURCHASE ORDERS
PO's /Orders | Supplier / Description |  | Sets / Category
 |  | 1000 | [NAME]
 |  |  |  |  |  |  | set / category
 |  |  |  |  |  | Code | Sets / Category
 |  |  |  |  |  | 2735-101 | EXT New York Streets - Inc Ext Cravath, Manhattan, 5th Ave  - NY | 2735-101
 |  |  |  |  |  | 2735-102 | Ext Mother House  - NY | 2735-102
 |  |  |  |  |  | 2735-103 | Int Mother House Library / Tech Centre - NY | 2735-103
 |  |  |  |  |  | 2735-104 | Ext Central Park  - NY | 2735-104
 |  |  |  |  |  | 2735-105 | Int Cravath Law Firm - Downstairs Lobby / Main Office / Conference Room / Bathroom - NY | 2735-105
 |  |  |  |  |  | 2735-106 | Int TSA - JFK Airport - Security Area - NY | 2735-106
 |  |  |  |  |  | 2735-107 | Ext Small Manhattan Cemetery - NY | 2735-107
 |  |  |  |  |  | 2735-108 | Ext Columbia University - NY | 2735-108
 |  |  |  |  |  | 2735-109 | Ext South Lawn - NY | 2735-109
 |  |  |  |  |  | 2735-110 | [NAME] | 2735-110
 |  |  |  |  |  | 2735-111 | Ext West Village - NY | 2735-111
 |  |  |  |  |  | 2735-112 | Int Helen's Office - New York Mother House  - NY | 2735-112
 |  |  |  |  |  | 2735-113 | Ext Washington Heights Streets - (Guy's Apartment) NY | 2735-113
 |  |  |  |  |  | 2735-114 | Int Apartment Building - (Guy's Apartment - inc Bedroom)  - 2nd Floor - NY | 2735-114
 |  |  |  |  |  | 2735-115 | Int New York Public Library  - Information Desk  - NY | 2735-115
 |  |  |  |  |  | 2735-116 | Int New York Public Library  - Rose Reading Room  -NY | 2735-116
 |  |  |  |  |  | 2735-117 | Int New York Coffee Shop -NY | 2735-117
 |  |  |  |  |  | 2735-118 | Int Anatole Home  (Young Guy)  - Flashback  - NY | 2735-118
 |  |  |  |  |  | 2735-119 | Int Train  - NY | 2735-119
 |  |  |  |  |  | 2735-120 | Ext Atlantic City Beach - New Jersey  - NY | 2735-120
 |  |  |  |  |  | 2735-121 | Int Golden Palm Condominium - Reception  - New Jersey | 2735-121
 |  |  |  |  |  | 2735-122 | Int Golden Palm Condominium Room - 7th Floor  - New Jersey (Guy's Foster Parents) | 2735-122
 |  |  |  |  |  | 2735-123 | Ext Golden Palm Condominium | 2735-123
 |  |  |  |  |  | 2735-124 | [NAME] | 2735-124
 |  |  |  |  |  | 2735-125 | [NAME] (Build?) - NY | 2735-125
 |  |  |  |  |  | 2735-126 | [NAME] | 2735-126
 |  |  |  |  |  | 2735-127 | [NAME], Elevator / Hallway | 2735-127
 |  |  |  |  |  | 2735-128 | [NAME] Penthouse Hallway  -NY ([NAME]?) | 2735-128
 |  |  |  |  |  | 2735-129 | Ext Dakota Penthouse  - Window Ledge ([NAME]?) | 2735-129
 |  |  |  |  |  | 2735-130 | Int / Ext Detroit Street - Hotchkiss Centre - Inc Front Desk / Day Room  - Guy's mum Hospital | 2735-130
 |  |  |  |  |  | 2735-131 | Int London Club, inc Bathroom, dancefloor - LN | 2735-131
 |  |  |  |  |  | 2735-132 | Int Soledad's Apartment - LN | 2735-132
 |  |  |  |  |  | 2735-133 | Int London Motherhouse, inc File Room, Parlour - LN | 2735-133
 |  |  |  |  |  | 2735-134 | Ext London Streets  - LN | 2735-134
 |  |  |  |  |  | 2735-135 | [NAME] [NAME]  - LN | 2735-135
 |  |  |  |  |  | 2735-136 | [NAME] (London East End Train tracks) | 2735-136
 |  |  |  |  |  | 2735-137 | [NAME] ? | 2735-137
 |  |  |  |  |  | 2735-138 | Int Heathrow Airport Arrivals  - LN | 2735-138
 |  |  |  |  |  | 2735-139 | Int 2nd Floor Flat - London  - Guys Rented Flat - LN | 2735-139
 |  |  |  |  |  | 2735-140 | Ext Piccadilly Circus  - Tube Station  - LN | 2735-140
 |  |  |  |  |  | 2735-141 | Ext Cupid's Error -Streert  - LN | 2735-141
 |  |  |  |  |  | 2735-142 | Int Cupid's Error Club - LN | 2735-142
 |  |  |  |  |  | 2735-143 | [NAME] Park | 2735-143
 |  |  |  |  |  | 2735-144 | [NAME] | 2735-144
 |  |  |  |  |  | 2735-145 | Int Porkie Pies Pub - LN | 2735-145
 |  |  |  |  |  | 2735-146 | [NAME] | 2735-146
 |  |  |  |  |  | 2735-147 | [NAME] | 2735-147
 |  |  |  |  |  | 2735-148 | Ext London Street - LN (Gridlock) | 2735-148
 |  |  |  |  |  | 2735-149 | Ext / Int Hotel - London - LN | 2735-149
 |  |  |  |  |  | 2735-150 | Ext Upscale Reastaurant - LN | 2735-150
 |  |  |  |  |  | 2735-151 | Int Restaurant  - Toilet - LN | 2735-151
 |  |  |  |  |  | 2735-152 | [NAME]  - Coffee shop? -  LN | 2735-152
 |  |  |  |  |  | 2735-153 | Ext Tennament House - Firescape  -  LN | 2735-153
 |  |  |  |  |  | 2735-154 | Int Keve's Apartment - LN | 2735-154
 |  |  |  |  |  | 2735-155 |  | 2735-155
 |  |  |  |  |  | 2735-156 |  | 2735-156
 |  |  |  |  |  | 2735-157 |  | 2735-157
 |  |  |  |  |  | 2735-158 |  | 2735-158
 |  |  |  |  |  | 2735-159 |  | 2735-159
 |  |  |  |  |  | 2735-160 |  | 2735-160
 |  |  |  |  |  | 2735-161 |  | 2735-161
 |  |  |  |  |  | 2735-162 |  | 2735-162
 |  |  |  |  |  | 2735-163 |  | 2735-163
 |  |  |  |  |  | 2735-164 |  | 2735-164
 |  |  |  |  |  | 2735-165 |  | 2735-165
 |  |  |  |  |  | 2735-166 |  | 2735-166
 |  |  |  |  |  | 2735-167 |  | 2735-167
 |  |  |  |  |  | 2735-168 |  | 2735-168
 |  |  |  |  |  | 2735-169 |  | 2735-169
 |  |  |  |  |  | 2735-170 |  | 2735-170
 |  |  |  |  |  | 2316-101 | Construction Equipment hire | 2316-101
 |  |  |  |  |  | 2316-102 | Workshop Equipment | 2316-102
 |  |  |  |  |  | 2316-103 | Standby Materials | 2316-103
 |  |  |  |  |  | 2316-104 | Ironmongery / Sundries | 2316-104
 |  |  |  |  |  | 2316-105 | Construction Labour | 2316-105
 |  |  |  |  |  | 2316-106 | Scenery Transport - 7.5 Tonne | 2316-106
 |  |  |  |  |  | 2316-107 | Printed  / Painted Backings | 2316-107
 |  |  |  |  |  | 2316-108 | Additional Construction Labour | 2316-108
 |  |  |  |  |  | 2316-109 | Scenery Transport  - Painters / Carpenters / Scenic | 2316-109
 |  |  |  |  |  | 2316-110 | [NAME] | 2316-110
 |  |  |  |  |  | 2316-111 | Skips - Construction / Props | 2316-111
 |  |  |  |  |  | 2316-112 | Set Removal | 2316-112
 |  |  |  |  |  | 2316-113 |  | 2316-113
 |  |  |  |  |  | 2316-114 |  | 2316-114
 |  |  |  |  |  | 2316-115 |  | 2316-115
 |  |  |  |  |  | 2316-116 |  | 2316-116
 |  |  |  |  |  | 2316-117 |  | 2316-117
 |  |  |  |  |  | 2316-118 |  | 2316-118
 |  |  |  |  |  | 2316-119 |  | 2316-119
 |  |  |  |  |  | 2316-120 |  | 2316-120
 |  |  |  |  |  | 2316-121 |  | 2316-121
 |  |  |  |  |  | 2316-122 |  | 2316-122
 |  |  |  |  |  | 2316-123 |  | 2316-123
 |  |  |  |  |  | 2316-124 |  | 2316-124
 |  |  |  |  |  | 2316-125 |  | 2316-125
 |  |  |  |  |  | 2316-126 |  | 2316-126
 |  |  |  |  |  | 2316-127 |  | 2316-127
 |  |  |  |  |  | 2316-128 |  | 2316-128