Hi team
i have a small complicated vlookup
- i have 4 datatables
DT1 "code" coloum should compare with DT2 “code” coloum data
if the code dt1 & dt2 “code” column data equal
need to send to DT4 as Reconciled
Challenge
some times in Dt1 Code column has lager values**(green)** in that time i should compare the dt 3 with “code” 1 Column (green color) & dt2 that found code
if any of the records cannot found it should send to unreconciled sheet
Any Activity to archive this
dt1.xlsx (8.9 KB) dt2.xlsx (8.8 KB) dt3.xlsx (8.5 KB) dt4.xlsx (8.8 KB)