Invalid identity number

Hi @llllllkt99

Read both data into two datatables using read range

Use for loop on second sheet datatable and inside use filter datatable to filter sheet1 datatable with the required values

In filter give column name as ‘identity number’ and value as currentrow(‘identity number’).tostring

Use if to check the row count after filter. Dt.rowscount if this is greater than zero then rou have match else no match

Cheers