I have two Excel Sheets, in these two sheets I have one reference column and want to compare the row data based on reference column and get that entire row data in new sheet with both sheet columns.
And also in that new sheet want to add 02 new columns
Required output like this with add two columns (Sheet 4)
How to achieve this ?