Lookup using two columns

[NIVED_NAMBIAR (NIVED N)]

Hi @MANISHA_V_ARORA

after a long testing

got this code

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“c_comp_prop_cd”)= If(dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).ToString.Trim)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“c_rev_center_cd”).ToString.Trim.Equals(row(“c_comp_prop_cd”).ToString.Trim) And r(“c_prop_cd”).ToString.Trim.Equals(row(“c_prop_cd”).ToString.Trim))(0)(“c_lms_rev_center_desc”).ToString, row(“c_comp_prop_cd”).ToString))

Result got

Regards,
Nived N
Happy Automation