Comparing excel

excel
activities

#1

image
SHEET1

image
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


#2

@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