There is Excel1( Sheet 1 & Sheet2). Cell 1(Column1) of sheet 2 needs to be compared with all values in column1 of Sheet 1. If the value matches, copy the values of column2&3 of matching row from sheet1 and paste it in Column2&3 of sheet2. This way all the cells of column1 of sheet 2 need to be comp…

Compare two columns from 2 different sheets

Vikas_M (Vikas M) July 21, 2023, 10:49am 7

Hey @ayushi_jain3
This works as you requested
Please find the xaml in the below attachment

Topic		Replies	Views
Comparing two sheets in excel Help	3	1907	April 28, 2020
Compare two columns in excel Help excel , activities	4	6917	August 7, 2018
Compare cell A of column1 with all cells of Column2 Studio studio , question , activities_panel	6	421	June 21, 2023
Comparison of two datatable Help	7	1379	August 9, 2019
Lookup using two columns in excel Activities excel , studio	3	268	December 5, 2023