Spreadsheet: 890059d1741206811-return-same-value-based-on-2-different-searches-masterprojectlist-test
Sheet: ENTRY SCREEN

JOB # | JOB NAME | STATUS | COUNTY | MAILING ADDRESS | CITY | STATE | ZIP | FULL ADDRESS | 01 - PROJECT EXECUTIVE | 02 - SR. PROJECT MANAGER | 03 - PROJECT MANAGER | 04 - ASST. PROJECT MANAGER | 05 - MECH SUPERINTENDENT | 06 - ELECTRICAL SUPERINTENDENT | 07 - SR PROJECT ENGINEER | 08 - PROJECT ENGINEER | 11 - SR. PROJECT ACCT | 12 - PROJECT ACCT | 13 - ASST PROJECT ACCT | 14 - FPA TEAM LEAD | 15 - PROJECT ADMIN
7102110 | BIG CYPRESS | ACTIVE | [NAME] | 65 BOB WHITE RD. | TURREL | AR | 72384 |  | SHANE IMBERT | DAN CUSHING,  [NAME] |  | DAN ANDREWS |  |  |  |  | KATIE WOOD | SUSAN GERASIMCHIK | [NAME] | SAMANTHA CORSON | HANNAN WALTERS
7102221 | DECATUR | ACTIVE | DECATUR | 532 ATTAPULGUS CLIMAX RD (532 HARRELL MILL RD) | CLIMAX | GA | 39834 |  | SHANE IMBERT |  | [NAME] |  |  |  |  |  | TYLER PANELLA-AYHENS | MARTHA ZAMORA | ERNESTINE YELLOWHAIR-DEAL | LASHUNDA PENNYWELL | LASHUNDA PENNYWELL
7102216 | DRIVER | ACTIVE | MISSISSIPPI | 1465 E. STATE HWY. 198 | OSCEOLA | AR | 72370 |  | WADE WILSON | CHRIS HOLZWORTH | BENJAMIN FRITZSCHE |  |  |  |  |  | KATIE WOOD | [NAME] | DANIELLE STANLEY | SAMANTHA CORSON | [NAME]
7102115 | FOXHOUND | ACTIVE | HALIFAX | 2040 GREEN VALLEY RD | CLOVER | VA | 24534 |  | SHANE IMBERT | KYLE SHEPARD | ABDUL IJAZ | SWAPNIL MARATHE |  |  |  |  | ELENA FICARRA | JACKSON CAMPBELL | ASHLEY PIERSON | JACQUELINE VILLEGAS | [NAME]
7102219 | HARVEST GOLD | ACTIVE | SUNFLOWER | 143 BOYER STEINER RD. | INDIANOLA | MS | 38751 |  | [NAME] | DAN CUSHING | [NAME] |  |  |  |  |  | KATIE WOOD | HEATHER MATTSEN | [NAME] MYERS | KAILEY DOVEL | [NAME]
7102224 | IBIS | ACTIVE | PALM BAY | 1106 CENTERLANE RD. | FELLSMERE | FL | 32948 |  | SHANE IMBERT | [NAME] FRANK | [NAME] |  |  |  |  |  | FAYE BOGGS | NANCY COLGAN |  | ANARAE UNDERHILL | ANARAE UNDERHILL
7102229 | PINEAPPLE | ACTIVE | ST. LUCIE | 11001 CARLTON RD. | PORT ST. LUCIE | FL | 34987 |  | SHANE IMBERT | [NAME] FRANK | ERICE CHRISTIAN |  |  |  |  |  | FAYE BOGGS | ENRIQUE PEREZ | TATIANA GUZMAN | KYA SPENCER | EBONY LEWIS
7102225 | PRAIRIE CREEK | ACTIVE | DESOTO | 4751 SE NOTTS DAIRY ST. | ARCADIA | FL | 34266 |  | SHANE IMBERT | [NAME] | JOHN FIORENZZI | [NAME] |  |  |  |  | FAYE BOGGS | ENRIQUE PEREZ | TATIANA GUZMAN | ANARAE UNDERHILL | ALYCIA SEGARRA
7102231 | SAMBUCUS | ACTIVE | MANATEE | 44300 SR-64 | [NAME] CITY | FL | 34251 |  | [NAME] | [NAME] | SONALI TARE |  |  |  |  |  | FAYE BOGGS | KATHY SPICER | ALISHA DAILEY | JACQUELINE VILLEGAS | JACQUELINE VILLEGAS
7102228 | SILVER PALM | ACTIVE | PALM BEACH | 7501 CAROL ST. | LOXAHATCHEE | FL | 33470 |  | SHANE IMBERT | [NAME] FRANK |  | AMANPREET UPPAL |  |  |  |  | FAYE BOGGS |  |  | KYA SPENCER | EBONY LEWIS
7102120 | [NAME] | ACTIVE | MARICOPA | 22615 S. SR 85 | [NAME] | AZ | 85326 |  | SHANE IMBERT | KYLE SHEPARD | BRIAN MALLERNEE |  |  |  |  | COLE TOLLET | KATIE WOOD | TYLER PANELLA-AYHENS | MARTHA ZAMORA |  | ERNESTINE YELLOWHAIR-DEAL
7102226 | TERRILL CREEK | ACTIVE | CLAY | 5345 HOGARTH RD. | GREEN COVE SPRINGS | FL | 32043 |  | SHANE IMBERT |  |  | [NAME] BOHRINGER |  |  |  |  | FAYE BOGGS | HEATHER MATTSEN | [NAME] MYERS | SAMANTHA CORSON | SAMANTHA CORSON
7102232 | THREE CREEKS | ACTIVE | MANATEE | 27255 SR 62 | DUETTE | FL | 34219 |  | [NAME] | [NAME] | [NAME] | CRISTINA BETANCOURT |  |  |  |  | FAYE BOGGS | SARAH VANDEVER |  | KYA SPENCER
7102108 | WACO | ACTIVE | WACO | [NAME]. 132 (125 CR 132) | MOUNT CALM | TX | 76673 |  | SHANE IMBERT |  | [NAME] | DEAN PECHILLO, [NAME] | [NAME] WALKER |  |  |  | TYLER PANELLA-AYHENS | TYLER PANELLA-AYHENS | RACHAEL ANDREWS | SAMANTHA CORSON | ANARAE UNDERHILL
7102220 | WASHINGTON COUNTY | ACTIVE | WASHINGTON | 1755 NEW RD | [NAME] | GA | 31082 |  | SHANE IMBERT | [NAME] |  | SAMUEL CHHOUN |  |  |  |  | TYLER PANELLA-AYHENS | TYLER PANELLA-AYHENS | RACHAEL ANDREWS | KAILEY DOVEL | AMBER ADAMS
7102227 | WHITE TAIL | ACTIVE | MARTIN | 16364 SW CITRUS BLVD. | PALM CITY | FL | 34990 |  | SHANE IMBERT | [NAME] FRANK | [NAME] | [NAME] |  |  |  |  | FAYE BOGGS | NANCY COLGAN |  | KYA SPENCER | KYA SPENCER