If I've understood what you're getting at... using the 100:jobs as an example:
First remove the validation, then I would suggest you store the appropriate Speeds column number in an appropriate cell, eg:
then ascertain customer count
B19: =COUNT(INDEX(Speeds,0,A19))
with the above in place now retrieve customer listing:
A21:
=IF(ROWS(A$21:A21)>B$19,"",INDEX(INDEX(Speeds,0,1),MATCH(TRUE,INDEX((INDEX(Speeds,0,A$19)*ISNA(MATCH(INDEX(Speeds,0,1),A$20:A20,0)))>0,0),0)))
copied down to A50
repeat the logic on the other tables.
Bookmarks