I have to compare column 2 of excel 1 and with column 2 of excel 2. If they match I have to extract the the cell value from colum1 of excel one corresponding to the match value of column 2 of excel 1

How to compare columns of two diiferent excel

Palaniyappan (Forum Leader) June 19, 2019, 1:08pm 2

Hi
we can use lookup datatable activity buddy
For more info on this
https://activities.uipath.com/docs/lookup-data-table

2 Likes

How to match two excel column data and copy next column data

Topic		Replies	Views
Comparing two excel sheet column values Help	9	1804	July 19, 2019
How to compare one row in excel E1 to all the rows present in E2(Excel2) Help activities	8	866	November 4, 2019
Comparing two sheets in excel Help	3	1831	April 28, 2020
HOW TO COMPARE TWO COLUMN VALUES Help	15	4886	October 21, 2019
How to compare 2 identical columns from different sheets in excel? Help excel , activities , question	10	2183	December 9, 2019