I need to fetch each row value in "LEmpID" column in Excel1.sxlsx. And compare it with all the row values in "CAT " column i.e Excel2. Here the CAT value is in D4 cell

Requirement
Note: I should not use two for loop

  1. I need to fetch each row value in “LEmpID” column in Excel1.xlsx.
    2.And compare it with all the Column values in “CAT” column i.e Excel2.
  2. Here the CAT value is in D4 cell ,it can be in any cell ,we need find CAT text and then iterate through the CAT column values
  3. update status in the excel 1 status column

Excel 1
Global Legacy LEmpID Company Gender status
456 DSC FR 45465 aws 1 3
6567 DSC FR 676 tyghgh 3 0
788 DSC FR 190126 ggg 2 2

Excel2
List Nominate 02/20

REG Cam Sar CAT NOM dfg dfg dfg
Test test test 123123
190126
453636
346346

.

@manoj.roczz, hi and welcome to the community.

Is this an assignment of some sort? who gives requirements like that for a project?, you shouldn’t use two for loops but compare two different datatables?

Yes initially i had done in 2 for loop, but later asked to change