Select multiple multiple cells adjacent to a date and populate a table

Hello there, I am new to the forum. I am looking for some help with the following:
I have two tables:
Table one has 2 columns, Column 1 has Part Numbers, Column 2 has Ship dates.
Table two has 365 Columns, each row header has a unique date.

I want to select a date in table two, then find the cell(s) that have that date within column 2 of table 1. Then i want to populate a column section in table 2 with those adjacent values.
Is there a specific formula for this?

Thanks in advance.

Fred

Hi, welcome to he forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Assuming that you want to populate E15:AB27 on sheet 2, then the following formula could be pasted into E15 and copied down to E27 and, while E15:E27 are still selected, across to AB27:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

I don't see any attachments.
Let us know if you have any questions.

The following formula seems to yield the expected results in the attached file:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

You're Welcome. If the formula resolves the issue please take a moment to mark the thread as 'Solved' using the thread tools drop down in the ribbon above your first post. I hope that you have a blessed day.