Create a column by comparing two columns in a merged table

[RohithGn]

 Hi,

I have merged two tables table 1 & 2 to Table 1 and now I want to comapare two columns containing similar data and to display if both values are equal or not.

here is the sample Input and output - 

Could you please help me out on this.

Thanks,

Rohith

[radpir · Accepted solution]

hi,

not sure i'm getting your question right but if you need to get what's in the New Column here's the formula"

= if [C2PC Status] = [MSX Status]  then "In Sync" else "Out of Sync"

hope this helps,

radpir

[smIqbal]

Hey Radpir, Suppose if you want a more complex scenario where you have to compare two columns of your active workbook with two columns residing in many Excel files in a folder having the same structure, how would you pull the data then. I believe an "AND" operator would do the trick but I have not been able to figure it out so far. By the way, I am using Excel 2016 Power Query. I also believe that since Power Query and BI have many similarities, my question can be answered here.

[smIqbal]

Hey Radpir, Suppose if you want a more complex scenario where you have to compare two columns of your active workbook with two columns residing in many Excel files in a folder having the same structure, how would you pull the data then. I believe an "AND" operator would do the trick but I have not been able to figure it out so far. By the way, I am using Excel 2016 Power Query. I also believe that since Power Query and BI have many similarities, my question can be answered here.

[RohithGn]

Just what i needed Thanks a ton Radpir!

Regards,

Rohith