COMPARING TWO EXCEL SHEETS

[uio (uipath test)]

Hi there,

I have two Excel sheets with two columns each.

Sheet 1 :- NAME & SALARY.

Sheet 2 :- RANGE & NAME.

How do I compare both the sheets and fill the names in the “Sheet 2” with the respective range of salary ?

My output must be like in the 3rd tile highlighted.

Thank you,
Uio

[ppr (Peter Preuss)]

we would suggest a modified approach

prepare some lookup helper by splitting the dt2 into a min and max column structrure like

Min,Max,Label
5000,10000,5000-10000
10000,15000,10000-15000

loop over the modifed dt2 and filter dt1 related to the min and max boundaries from current looped row. From the filter result you can concat the names