Compare three columns in three sheets

Closed

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

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.

Compare three columns in three sheets
Beyond compare - Download - File management
Display two columns in data validation list but return only one - Guide
Google sheets rtl - Guide
How to compare two excel sheets - Guide
Mark sheet in excel - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 4, 2015 at 11:29 AM

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

Similar discussions

Comparing columns and returning value

Comparing Two Excel Sheets and copying like data to third sheet

VBA Compare 2 sheets and output difference to 3rd sheet

Macro to compare 2 sheets and copy differences

Similar discussions

Subscribe To Our Newsletter!