So I have an excel table of employees and the routes that they have driven. Im trying to make a formula that will Use a reference cell to return a list of the names of the drivers who know a specific route. I have been messing around with the Index, Match, And Lookup formulas, but Im new to this and not entirely sure how to do it. The formatting of the table is a bit weird because of how the report is generated. The names of the drivers are the row titles and the routes are the column titles. Its a really large table with many drivers so Id like to avoid changing the format of the table so I can just copy and paste when there are updates, but still have the reference cell that I am able to use to generate the list.

This is what the table looks like:

I would like to be able to use a formula to enter a route number and have excel return a list of Drivers who have driven that route.

Clipboard 19 Font Alignment 19 Number Styles | B17 y for A B C D E F G H 1 30A 40B 42B 35B 38C 430 410 310 2 40B 3 42B 35B 38C 4 Shannon BOA Williams Miller Jackson 30A Adams 40B 430 410 5 6 40B 42B 38C 310 17 8 9 10 Route: 30A 11 12 13 14 15 16 17 18 19 20 21 22 Font Clipboard 2 Alignment Number Styles B17 A B D E F G H 42B 35B 38C 430 410 310 40B 40B 42B 35B 38C 1 30A 2 Shannon 30A 3 Williams 4 Miller 5 Jackson 30A 6 Adams 7 40B 43C 41C 40B 42B 38C 31C 8 9 10 Route: 30A 11 12 13 14 15 16 17 18 19 20