Spreadsheet: 821147d1678465566-formula-help-next-available-record-with-conditions-lhs-tool-revised
Sheet: Farms and Catchers

 |  |  | Farm | Farm | Houses | Head Capacity | Drive Time | Number of Trailers | Full Trailers | [NAME]. | Trucks/House |  | Catchers | Trailer Numbers |  | Driver No | Drivers Name | [NAME]
 |  |  | AARON NOLT FARM 1 |  |  |  |  |  |  |  |  |  | Kauffman #1 | 782 |  | 220875 | [NAME] | Spare
 |  |  | AARON NOLT FARM 2 |  |  |  |  |  |  |  |  |  | Kauffman #2 | 784 |  | 260482 | [NAME] | 539
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Kauffman #3 | 785 |  | 305691 | [NAME] | 542
 |  |  | AJ STROUP |  |  |  |  |  |  |  |  |  | Kauffman #4 | 786 |  | 261082 | [NAME] | Spare
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Kauffman #5 | 787 |  | 208067 | [NAME] | 850A
 |  |  | ALLEN K WEAVER |  |  |  |  |  |  |  |  |  | Crew #1 | 788 |  | 210000 | [NAME] | 545
 |  |  | ALVIN NOLT |  |  |  |  |  |  |  |  |  |  | 789 |  | 109198 | [NAME] | Spare
 |  |  | AMOS NEWSWANGER |  |  |  |  |  |  |  |  |  |  | 790 |  | 233360 | [NAME] | 432
 |  |  | AMOS NOLT |  |  |  |  |  |  |  |  |  |  | 791 |  | 106709 | [NAME] | Spare
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 792 |  | 204726 | [NAME] | 847A
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 793 |  | 222613 | [NAME] | 547
 |  |  | ART GROFF |  |  |  |  |  |  |  |  |  |  | 794 |  | 234171 | [NAME] | 440
 |  |  | ARVIN HORST |  |  |  |  |  |  |  |  |  |  | 795 |  | 260925 | [NAME] | 538
 |  |  | AUKER FARMS LLC |  |  |  |  |  |  |  |  |  |  | 796 |  | 213852 | [NAME] | 546
 |  |  | BELLAIRE FARMS LLC |  |  |  |  |  |  |  |  |  |  | 797 |  | 215918 | [NAME] | 439
 |  |  | BELLAVISTA FARM |  |  |  |  |  |  |  |  |  |  | 798 |  | 239742 | [NAME] | 544
 |  |  | BEN MOYER |  |  |  |  |  |  |  |  |  |  | 799 |  | 241420 | [NAME] | 540
 |  |  | BENJAMIN N MARTIN |  |  |  |  |  |  |  |  |  |  | 800 |  | 236580 | [NAME] | Spare
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 801 |  | 259336 | [NAME] | Spare
 |  |  | BRENDLE [NAME] |  |  |  |  |  |  |  |  |  |  | 802 |  | 10056 | [NAME] | Spare
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 803 |  | 262444 | [NAME] | 543
 |  |  | BRETT EBERLY |  |  |  |  |  |  |  |  |  |  | 804 |  | 262090 | [NAME] (Stogie) | 537
 |  |  | BRETT WAGNER |  |  |  |  |  |  |  |  |  |  | 805 |  | 300012 | [NAME] | 535
 |  |  | [NAME] FARM 1 |  |  |  |  |  |  |  |  |  |  | 806 |  | 261518 | [NAME] | 534
 |  |  | [NAME] FARM 2 |  |  |  |  |  |  |  |  |  |  | 807 |  | 306457 | [NAME] | Spare
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 808 |  | 303714 | Travis Belcher | Spare
 |  |  | BRIAN MUSSER |  |  |  |  |  |  |  |  |  |  | 809
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | BURNELL NOLT
 |  |  | CEDAR GLEN FARMS
 |  |  | CEDAR HILL POULTRY LLC
 |  |  | [NAME]
 |  |  | [NAME] 1
 |  |  | [NAME] 2
 |  |  | CRYSTAL SPRING FARM
 |  |  | CURRY WAGNER
 |  |  | CURT ZIMMERMAN
 |  |  | CURTIS LEHMAN
 |  |  | CURVIN GOOD
 |  |  | DALE BRUBAKER
 |  |  | DAN E MARTIN
 |  |  | DAN MUSSELMAN
 |  |  | DARYL REIFF
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | DEAN PATCHES
 |  |  | DEAN WEINHOLD
 |  |  | [NAME]
 |  |  | DEIHL'S POULTRY
 |  |  | DENNIS RIFE
 |  |  | DOUBLE B GRAIN, INC I
 |  |  | DOUBLE B GRAIN, INC II
 |  |  | EDWIN HORNING
 |  |  | EDWIN NEIDIG
 |  |  | ELTON NOLT
 |  |  | ELVIN MARTIN
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | FLINT ROAD FARMS LLC
 |  |  | [NAME]
 |  |  | GEHERS POULTRY FARM
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | GORDON KOPP
 |  |  | GREENBAR POULTRY LLC
 |  |  | GREG HERR
 |  |  | [NAME]
 |  |  | HACKENBERGER FAMILY FARM LLC
 |  |  | HAROLD KREIDER FARM 1
 |  |  | HAROLD KREIDER FARM 2
 |  |  | HESS BROTHER POULTRY LLC
 |  |  | HIDDEN CREEK POULTRY LLC
 |  |  | IMES POULTRY
 |  |  | J & N TROUTMAN LLC
 |  |  | JACOB LIGHT
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | JASON ECENROAD
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | JAY E GINGRICH
 |  |  | [NAME]
 |  |  | [NAME] BOMGARDNER
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | JEFFREY L SENSENIG
 |  |  | [NAME]
 |  |  | JERDON FARMS
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | JOHN LIGHT
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | KEITH MARTIN FARM 1
 |  |  | KEITH MARTIN FARM 2
 |  |  | [NAME]
 |  |  | KERVIN HURSH
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | LAMAR LEHMAN
 |  |  | LAMAR MOYER
 |  |  | LAMAR RUPPERT
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME] EBY
 |  |  | LEONARD MARTIN
 |  |  | LINFORD MARTIN
 |  |  | LITTLE HILL FARM LLC
 |  |  | [NAME]
 |  |  | LOREN STONER
 |  |  | [NAME]
 |  |  | MATTHEW NOLT
 |  |  | MERLE WEAVER
 |  |  | MICHAEL LONG
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | MOUNTAIN VIEW HOLSTEINS
 |  |  | MOYER POULTRY FARM
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | NEWPORTS SPRING FARM LLC.
 |  |  | NEWSWANGER FAMILY FARM LLC
 |  |  | PRESTON BOOP
 |  |  | RAY WEAVER
 |  |  | RICHARD MANEVAL
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME] MOLNAR
 |  |  | RYAN RUTT
 |  |  | SHALE-ROCK ACRES
 |  |  | SHAWN MARTIN
 |  |  | SUNSET FAMILY FARMS LLC
 |  |  | SUSAN ALLEMAN
 |  |  | SUZANNE REISINGER
 |  |  | TERRACE VALLEY FARMS LLC
 |  |  | THISTLE CREEK FARM, LLC
 |  |  | [NAME], LLC
 |  |  | TROY GELSINGER
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | WATERFRONT POULTRY
 |  |  | WEILER FARMS
 |  |  | WINDING CREEK POULTRY FARM
 |  |  | ZIEGLER BLUE MOUNTAIN GAME FARM