|
Excel Three coloumn comparison
Hi Guyz,
I am looking to compare three column in excel file and copy the data in 4th column
Column1:Data1
Column2:Data2
Column3:Data3
Column4:Data4 (Result data)
What I want to do is to compare similar data in Column 1 and Column 3, if the data matched, copy data from Column 2 and paste it in Column 4.
Please see the attached sample jpg file.
Regards,
Aejaz
|