Thread: Use Table to Auto Populate Other Tables

I have attached a spreadsheet that a printing department uses.

Right now, on the Standards tab, you can choose a customer from the drop down and if you have set a speed that the job can run at on the Speeds tab, it will populate using a vlookup.

However, I would like to make it more intuitive.

Is there a way to make it so that by setting speeds under each machines column on the Speeds tab, it will auto populate (in alphabetical order) under each machines table on the Standards tab?

My first thought is that it would somehow use the INDEX or MATCH functions, but not exactly sure how to implement it.

Thanks!

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:

A19: 2

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.