Comparing excel

[shruti (ss)]

SHEET1

SHEET2

IN 2ND COLUMN OF SHEET 1 I NEED TO INGORE IF ITS VALUE IS “0” I NEED TO COMPARE WITH NEXT VALUE OF SHEET 2

RESULT

[rajeshprabhu_gp (Rajesh prabhu)]

@shruti

Old question, any how replying to it

excel Way - concat all 4 columns into one in both sheets and do Vlookup

Uipath Logic - read both sheet into Datatable - two for each and IF will do the same.

Thanks~Rajesh