Check any value from one column in excel workbook exist in another column in other excel workbook

[hsendel]

Dears,

I found a very useful forum doing the same, but my query is to select each value not only one selected item using : .Select(“[ColumnName]=‘Value’”)

Ref. Check if the values from one column in excel workbook exist in another column in other excel workbook

My example is attached here for 2 WorkkbooksWorkBook1.xlsx (10.5 KB) WorkBook2.xlsx (10.2 KB)

[hsendel]

At the End , I need to get the following cells highlighted in yellow :

[Manjuts90]

@hsendel Can you tell on what basis you have get this values.

[hsendel]

Hi Manjusts,

Those values will be highlighted after comparison between 2 attached excel sheets as follows :Check in 1st DataTable" DaysList" if the values are exists in 2nd DataTable"ThisMonthsDays", If So it will highlight them in Yellow or Print them in 3rd DataBase.

[TOHF (Tom Frederiksen)]

Hi,

it sounds like a VLOOKUP

try this one: Excel Vlookup Using UiPAth - #2 by arivu96

/Tom

[hsendel]

Thanks TOHF and Welcome to UiPath Cumminity
I will check the link and update you.

[hsendel]

I fixed the issue by using :
1- Read both Database : DT1 & DT2
2- Output the result to DT3
3-“Join Data Tables” with “Inner” type
4- Save the result to excel using : Write Range
Thx