Use Table to Auto Populate Other Tables

[ffmariners]

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!

[ffmariners]

Bump

If you don't think it's possible (or achievable without A LOT of work), let me know that too!

Thanks

[DonkeyOte]

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:

Please Login or Register  to view this content.

then ascertain customer count

Please Login or Register  to view this content.

with the above in place now retrieve customer listing:

Please Login or Register  to view this content.

repeat the logic on the other tables.

[ffmariners]

Thanks! That worked brilliantly!

I knew it had to do with Index and Match