Spreadsheet: 860846d1708870810-non-sequential-row-problem-non-sequential-data-set
Sheet: Irregular row sequence

Final
UMBC
Retrievers
56
Maine
Black Bears
62
Final |  | Hey, [NAME]. Thank you for your help on this problem. Frankly, I'm an excel novice. Here is the data set. I want to be able to drag Columns B, C, D down nearly 2000 cells
 |  | and maintain the irregular row sequence down the columns so that Columns B, C, D pull that data out of Column A, much the same way your original INDEX FORMULA
North Carolina A&T |  | did for the first irregular sequence. I hi-lighted corresponding cells. Thank you, sir, for your generous help on this problem.
Aggies
64
[NAME]
Seawolves
80
Final
Central Arkansas
Bears
65
Bellarmine
Knights
68
Final
[NAME]
Bearcats
80
[NAME]
River Hawks
87
Final
Hampton
Pirates
72
Campbell
Fighting Camels
68
Final
Charleston
Cougars
90
Delaware
Blue Hens
71
Final
[NAME]
Raiders
93
Detroit Mercy
Titans
78
Final
North Alabama
Lions
72
Eastern Kentucky
Colonels
75
Final
Liberty
Flames
71
Florida International
Panthers
76
Final
SMU
Mustangs
70
Florida Atlantic
Owls
80
Final
Drexel
Dragons
57
Hofstra
Pride
69
Final
Le Moyne
[NAME]
64
LIU
Sharks
76
Final
N.J.I.T.
Highlanders
78
New Hampshire
Wildcats
83
Final
Elon
Phoenix
58
Northeastern
Huskies
61
Final
Appalachian State
Mountaineers
82
Old Dominion
Monarchs
67
Final
Rutgers
Scarlet Knights
68
(3) Purdue
Boilermakers
96
Final
Oakland
Golden Grizzlies
63
[NAME]
Colonials
43
Final
Queens University
Royals
83
[NAME]
Hatters
75
Final
Monmouth
Hawks
61
Towson
Tigers
80
Final
Central Connecticut State
Blue Devils
73
Wagner
Seahawks
72
Final
[NAME]
Seahawks
81
William & Mary
Tribe
65
Final
Radford
Highlanders
90
Gardner-Webb
Runnin' Bulldogs
74
Final
FDU
Knights
91
[NAME]
Pioneers
99
Final
Vermont
Catamounts
94
Albany
Great Danes
80
Final
[NAME]
Owls
74
Florida Gulf Coast
Eagles
67
Final
Cleveland State
Vikings
73
Northern Kentucky
Norse
75
Final
St. Francis (PA)
Red Flash
60
Merrimack
Warriors
71
Final
California Baptist
Lancers
65
[NAME]
Wildcats
71
Final
Texas State
Bobcats
76
Georgia Southern
Eagles
84
Final
Ohio State
Buckeyes
79
Minnesota
Golden Gophers
88
Final
Eastern Washington
Eagles
71
Northern Arizona
Lumberjacks
78
Final
Idaho
Vandals
62
Northern Colorado
Bears
76
Final
Little Rock
Trojans
83
Southeast Missouri State
Redhawks
61
Final
South Alabama
[NAME]
83
Southern Miss
Golden Eagles
64
Final
Southern Utah
Thunderbirds
85
Texas-Arlington
Mavericks
90
Final
Grand Canyon
Antelopes
74
[NAME]
Texans
77
Final
Oral Roberts
Golden Eagles
70
Omaha
Mavericks
71
Final
Texas Rio Grande Valley
[NAME]
59
Utah Valley
Wolverines
70
Final
St. Thomas
Tommies
50
North Dakota State
[NAME]
64
Final
Kansas City
Roos
82
South Dakota
Coyotes
78
Final
Denver
Pioneers
70
South Dakota State
Jackrabbits
97
Final
Louisiana
[NAME]' Cajuns
59
Louisiana-Monroe
Warhawks
66
Final
Eastern Illinois
Panthers
73
Tennessee State
Tigers
78
Final
SIU-Edwardsville
Cougars
78
Tennessee Tech
Golden Eagles
77
Final
Morehead State
Eagles
78
Western Illinois
Leathernecks
57
Final
Tennessee-Martin
Skyhawks
106
Lindenwood
Lions
82
Final OT
Washington
Huskies
84
Arizona State
Sun Devils
82
Final
Troy
Trojans
71
Arkansas State
Red Wolves
79
Final
Sacramento State
Hornets
61
Montana
Grizzlies
68
Final
Portland State
Vikings
67
Montana State
Bobcats
72
Final
[NAME]
Bearkats
79
New Mexico State
Aggies
58
Final
Michigan
Wolverines
62
Northwestern
Wildcats
76
Final
Gonzaga
Bulldogs
86
Portland
Pilots
65
Final
Louisiana Tech
Bulldogs
65
UTEP
Miners
59
Final
Oregon State
Beavers
73
California
Golden Bears
81
Final
[NAME]
Mustangs
50
Cal State [NAME]
Titans
68
Final
Cal State Bakersfield
Roadrunners
66
Long Beach State
Beach
79
Final
[NAME]
Aggies
66
Cal State Northridge
Matadors
65
Final
[NAME]
Lumberjacks
49
Seattle
Redhawks
69
Final
UC [NAME]
Tritons
77
UC Riverside
Highlanders
65
Final
(21) Washington State
Cougars
77
(4) Arizona
Wildcats
74
Final
UC Santa Barbara
Gauchos
69
UC [NAME]
Anteaters
81
Final
Loyola Marymount
Lions
55
Santa Clara
Broncos
65
Final
Oregon
Ducks
78
Stanford
Cardinal
65