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
Bookmarks