Spreadsheet: 844750d1696443024-testing-multiple-conditions-in-one-cell-from-multiple-lists-book3
Sheet: Sheet2

 |  |  |  |  | 2023-10-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1a | 1b | 2 | 2a | 2b | 3 | 3a | 3b | 4 | 4a | 4b | 5 | 5a | 5b | 6 | 6a | 6b | 7
 | 74100666-0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Auburn | Issaquah | Issaquah | Auburn | Buckley | Buckley | Auburn | Auburn | Bainbridge Island | Auburn | Auburn | Bellevue | Covington | Covington | Kirkland | Bothell | Sultan | Sultan | Vashon
 | 74252193-0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kent | Sammamish, Washington | Sammamish, Washington | [NAME] | Enumclaw | Enumclaw | [NAME] | [NAME] | Kingston | Des Moines | Des Moines | Seahurst | Black Diamond | Black Diamond | Redmond | [NAME] | Monroe | Monroe | [NAME]
 | 74202726-0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Preston | Auburn | Sumner | [NAME] | [NAME] | Edgewood | Edgewood | Bremerton | SeaTac | SeaTac | [NAME] | Issaquah | Issaquah | Kenmore | Shoreline | [NAME] | [NAME] | Indianola
 | 74279876-0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Covington | Carnation | Kent | Bonney Lake | Tacoma | Lakewood | Milton | Milton | Poulsbo | Tukwila | Tukwila | Kirkland | Kirkland |  | Bothell | Lynnwood | Shoreline | Bothell | Langley
 | 74241385-0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maple Valley | Fall City | [NAME] | Orting | Lakewood | Tacoma | Federal Way | Federal Way | Silverdale | Newcastle | Newcastle | Redmond | Redmond |  | [NAME] | Duvall | Snohomish | Duvall | Hansville
 | 74052882-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Black Diamond | North Bend | Covington | Puyallup | Steilacoom | Steilacoom | Fife | Fife |  | Mercer Island | Mercer Island | Kenmore | Kenmore |  |  | Mukilteo | Lake Stevens |  | Cinebar
 | 74167368-0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Issaquah | [NAME] | Maple Valley |  | Auburn | [NAME] | [NAME] | [NAME] |  | Burien | Burien | Sammamish | Bothell |  |  | [NAME] | Marysville |  | Freeland
 | 74202404-0 |  |  |  |  |  |  | a | aa | b |  |  |  |  |  |  |  |  |  |  |  |  |  | Sammamish, Washington | [NAME] | Black Diamond | [NAME] | [NAME] | DuPont | Tacoma | Tacoma |  | [NAME] | [NAME] | Woodway | [NAME] |  |  | Snohomish | Arlington |  | Lakebay
 | 74031182-0 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Preston | Cle Elum |  | Buckley | Sumner | [NAME] | Fircrest | Fircrest |  | Bellevue | Medina | [NAME] |  |  |  | Monroe | Stanwood |  | Longbranch
 | 74202456-0 |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carnation |  |  | Enumclaw | Bonney Lake | [NAME] | University Place | University Place |  | Seahurst | Seattle |  |  |  |  | Lake Stevens | Mount Vernon |  | Vaughn
 |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fall City |  |  | Eatonville | Orting | [NAME] | [NAME] | [NAME] |  | [NAME] | Lake Forest Park |  |  |  |  | Marysville | Lynnwood |  | Camano Island
 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North Bend |  |  | [NAME] | Puyallup | Tenino | Bainbridge Island | Gig Harbor |  | Medina | Brier |  |  |  |  | Arlington | Mukilteo |  | Silver Creek
 |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Tacoma | Eatonville | Olympia | Gig Harbor | Fox Island |  | Seattle | Mountlake Terrace |  |  |  |  | Sultan |  |  | [NAME]
 |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Lakewood | Ashford | [NAME] | Kingston | Port Orchard |  | Kirkland | Edmonds |  |  |  |  | Stanwood |  |  | Gold Bar
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cle Elum |  |  | Ashford | [NAME] | [NAME] | Fox Island |  |  | Redmond | Lynnwood |  |  |  |  | Mount Vernon |  |  | Allyn
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Chehalis | Bremerton |  |  | Kenmore | [NAME] |  |  |  |  |  |  |  | Burlington
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Steilacoom | Glenoma | Shelton | Port Orchard |  |  | Sammamish |  |  |  |  |  |  |  |  | Marrowstone
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Mossyrock |  | Poulsbo |  |  | Lake Forest Park |  |  |  |  |  |  |  |  | Onalaska
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Glenoma |  |  | Silverdale |  |  | Brier |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DuPont |  |  | Belfair |  |  | Mountlake Terrace |  |  |  |  |  |  |  |  | Seabeck
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Union |  |  | Edmonds |  |  |  |  |  |  |  |  | Sedro-Woolley
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mossyrock |  |  | Shelton |  |  | Lynnwood |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Coupeville
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | Woodway |  |  |  |  |  |  |  |  | Oak Harbor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tenino |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Port Hadlock-Irondale
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Olympia |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bow
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Port Townsend
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Anacortes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chehalis |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shelton |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Darrington
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Toledo
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Concrete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Silver Lake
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Littlerock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tahuya
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Castle Rock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ferndale
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lilliwaup
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hoodsport
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skamania
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stevenson
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Woodland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kalama
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kelso
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Washougal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sequim
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vancouver
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sandy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday Harbor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blaine
 |  |  |  |  |  | 1 | int | ext | mw | 1a | int | ext | mw | 1b | int | ext | mw | 2 | int | ext | mw | 2a | int | ext | mw |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | McCleary
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scappoose
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 74100666-0 |  |  |  | 74031182-0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oregon City
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 74252193-0 |  |  |  | 74202456-0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | White Salmon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bingen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Elma
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cathlamet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Port Angeles
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Montesano
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | McMinnville
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aberdeen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ellensburg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Astoria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kittitas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ocean Park
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wenatchee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grayland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bend
 |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | East Wenatchee
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manzanita
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ocean Shores
 |  |  |  |  |  | 2b | int | ext | mw | 3 | int | ext | mw | 3a | int | ext | mw | 3b | int | ext | mw | 4 | int | ext | mw |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orondo
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pacific Beach
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Moclips
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chelan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quincy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kennewick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spokane Valley
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winlock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rochester
 |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 |  |  |  |  |  | 4a | int | ext | mw | 4b | int | ext | mw | 5 | int | ext | mw | 5a | int | ext | mw | 5b | int | ext | mw
 |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 |  |  |  |  |  | 6 | int | ext | mw | 6a | int | ext | mw | 6b | int | ext | mw | 7 | int | ext | mw | 7a | int | ext | mw
 |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total