Hi, I have two excel sheets .The task is to check each value in a column in the first excel is present or not in a particular column in the second excel. for example if the first sheet has multiple columns and one of them is Employer Name while the second sheet also has as many as 50000 records an…

Finding a value from each row in a column in one excel with another column in another excel

ddpadil (Dilip) September 19, 2017, 9:23am 2

Hi,
please search before posting
reference 1
reference 2

Topic		Replies	Views
Comparing columns in a data table and updating columns Help excel	1	2056	September 18, 2017
Searching a value from one column in excel to another column in other excel Help excel , activities	6	6161	November 16, 2017
How to search specific values in whole excel sheet Help activities	2	3946	April 19, 2018
How to find entire data in one column to another two excel Studio datatable , excel , studio , question , use-excel-file , linq , excel-scope , datatable-filter , excel-tables , join-data-tables , linq-query	1	1218	September 16, 2021
How to find particular matching column values to one excel to another excel Activities excel , activities , question , excel-scope , large-excel-files , excel-tables	6	1715	October 13, 2021