Previous Topic Next Topic

Compare three columns in three sheets

Closed
Summer - 4 Nov 2015 à 06:38
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 4 Nov 2015 à 11:29
Hello,

I have two excel sheets. Sheet 1 has A,B,C,D columns and sheet 2 has A,B,C columns.Now I want to compare A,B,C columns in both the sheets. If all the three values of sheet 1 matches with 3 values of sheet 2 copy D of that row from sheet 1 to sheet 2. Can someone help me with this problem? Thanks in advance.
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
4 Nov 2015 à 11:29
most easy way would be that for sheet1, have a place where column A, B, C are combined into one cell followed by the value of column D. once that is done, you can then use vlookup to compare and populate the column in sheet 2