Consolidate and Vlookup (join) data

[bubblyjai1982]

Hi All,

Could you please help me on below.

I have a data into different sheets which scramble comments and able to consolidate into one tab but unable to pull the correct comments.

Example  

1. Recon Comments: CADBRL is blank 

2. BIDASK comments: CADBRL has comment "Match"

3. Final MDX comments: CADBRL has comment "Match"

I have consolidated all these into one tab and tried using find and replace tool (Vlookup) to pull the comments.

So I'm expecting the output should be "CADBRL = Match" irrespective of any tab or comments is blank.

Input and output file attached for your reference.

Thank you in advance !!

[OTrieger · Accepted solution]

@bubblyjai1982 

First you should union the data based on Position and not Name, this will give you 2 columns with the data. Add a filter to remove the empty rows and then Unique tool to get one result for each type and you will end with the result that you want to have.

[bubblyjai1982]

Thank you, Sounds good !!