Once again, I have come to seek assistance from the excel masters that grace this forum.
I am trying to create list of values based on a selection from a Data Validation Dropdown List.
Now previously when I used this technique, I only had to return 1 value, so a simple vlookup function did the trick, but this time, its proving a bit more complex.
I have a list of labor crews with details for each worker
IE: Crew 3-1
-1 Foreman, Productivity: 5, Rate: 25
-1 Common, Productivity: 3, Rate: 14
Crew 3-2
-1 Foreman, Productivity: 10, Rate: 25
-1 Bricklayer, Productivity: 8, Rate: 20
-1 Common, Productivity: 3, Rate: 14
Basically, I have a dropdown list with the available crews. From that selection I would like to populate the adjacent cells with all the labors corresponding to that corresponding crew.
Researching, I found some answers with array formulas, but was having trouble understanding/applying to this instance. have attached a sample, that I have been working on and would appreciate any guidance possible.
Thank you
Bookmarks