INDEX MATCH in a List Data Validation

I need to create a drop down list based on matching a cell to a table on another tab.
For example on the Manual_Rates tab cell B1 needs to provide the applicable rows that match the applicable values on the Lists tab in row A1:CS1

If B1 = 0A than the drop down in cell B3 should have the values:
FRXDX
FRXDY
FRXDZ
FRXFB
FRXFC
FRXFD
FRXFE
FRXFF
FRXFH
FRXFI
FRXFL
FRXFM
FRXFN


I also need to create another drop down on the Manual_Rates tab cell B1 needs to provide the applicable rows that match the applicable values on the Lists tab in cells DB1:GP1

If B1 = 0A than the drop down in cell B5 should have the values:
CHIR10A
CHIR15A
CHIR20A
CHIR25A
CHIR30A

=OFFSET(Lists!$A$2,0,MATCH($B$1,Lists!$a1:$cs1,0)-1,15,1)

=OFFSET(Lists!$da$2,0,MATCH($B$1,Lists!$a1:$cs1,0),7,1)

Thank you so much this worked perfect