Multiple lookup & match problem

[agoodson1956]

I type a Job name in A1 and a job number in B1

In A12 through A32 I have Job Names
In B12 through B32 I have Employee names
In D10 through J10 I have the weeks dates
In D12 through J12 running down the column to D32 through J32 I have job numbers that match the job names
I want the employees in column B12 through B32 that are on that job to show in column M10 through M20.

The job might have only 1 employees or as many as 10 and I want them in sequential order.

This is over my head

 

[Peter_SSs]

I'm struggling to understand that enough to set up a small sample to test with. Could you make up a small set of dummy data (rows 12-17 should do instead of 12-32 and dates in column D10:F10 instead of D:J) and show us what that looks like, together with the expected results?

My signature block below has help with how to do that in a form we can easily see and copy/paste from to test with.

 

[agoodson1956]

http://www.awgoodson.com/help.jpg

 

[agoodson1956]

I need the employees names to go in the NAMES column

 

[Peter_SSs]

That gives a little idea of what your data is like but ..
- It is hard to read
- I can't copy/paste from it as requested. It would take a lot of typing to set that up (even if I could read it clearly).
- It doesn't include the expected results as requested.
- A smaller sample, as requested, should make it easier to set up, understand & test.

 

[agoodson1956]

http://www.awgoodson.com/Schedule.xlsm

 

[Peter_SSs]

http://www.awgoodson.com/Schedule.xlsm

Well, that is easier to read and I can copy from it but it seems you do not want to simplify this so helpers can understand it better.
So as it stands, this question is not for me. Perhaps somebody else can see through that enormous amount of data and lack of expected results and know what you want and how to get it.

If you can distil it to something simple, with results, then I may re-enter.

 

[agoodson1956]

Peter_SSs I don't know how to make it any easier? All I want is to put in the project number and the date and have the employees working on the project on that date to auto list in the names column? I can't figure out how to make that happen.

 

[Peter_SSs]

Peter_SSs I don't know how to make it any easier?

Make up a file with just a single sheet. If the sections above row 443 are relevant to getting the answers, just choose an appropriate 3 or 4 of those 10-row sections if you can, not 40.
In the Rows 448+ just include say 5 or 6 rows.
For the date columns just have 3 or 4.
Fill in the relevant data manually that will give a small set of results (say 3 names)
Include the expected results and explain how you manually work out those expected results
You may have to fiddle the numbers a bit to get something like that to work to actually produce some results (manually) but I'm sure it would help.
Post that data.

 

[agoodson1956]

http://www.awgoodson.com/Schedule1.xlsx If you change the date in cell V6 this task sheet will populate with new information based on whom is pulled up in the dropdown menu in cell S21. I need the cells under the dropdown to to populate with all the techs for that date and that Foreman that is in cell S21.

The cells in starting with B445 across the sheet to J445 and down grab the information from B3 across the sheet to J3 and down.

The information in cells O448 across to Z448 and down is my attempt at capturing the information but it does not seem to capture everyone. With the options I have picked in cells V6 ans S21 it should have listed 9 techs it only has 7.