Hello and thank you for any assistance you can provide.
In the attached file, I have two sheets with data: Internal Source Data, and Outside Source Data.
I have a tab titled Desired Result, which illustrates the end result I'm trying to achieve - which is basically to take the date from the Internal and Outside Source Data sheets, separate and align them based on the Unique ID.
I have issues using Vlookup or Index/Match, because the amounts of rows for each Unique ID are not always congruent.
Also, I have a macro (thank you jindon!) which fills in formulas in rows J through L. I can get them to populate in the appropriate areas, but the formulas are returning 0. I'm not sure what I'm missing there.
Furthermore, is this something that is better handled by a Pivot Table, or some other means?
Bookmarks