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

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)

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

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

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.

Hi,

it sounds like a VLOOKUP

try this one: Excel Vlookup Using UiPAth

/Tom

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

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.