This one got me the closest but it also removed data that I needed from the PS.xls
So.. I created this sample excel that has two sheets. Pretend each sheet is a separate file. I put data from MS and data from PS in each one. I need the MS data to NOT change at all- when I ask for Project.. I just want Project from MS.
When I pull data from PS- I expect to see every project in PS but the additional info from MS that aligns. IE Where PS 'A' matches something in MS 'Project' then display all the extra MS columns. Otherwise just give me the PS 'A' value with blanks in all the other columns.
The problem here is that i'm getting data from the MS table that I don't want.. for example if MS and PS both have Project 'A' but MS also has Project 'A.2'- I do not want both A and A,2 to come out but that's what's happening.