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.
we would suggest a modified approach
prepare some lookup helper by splitting the dt2 into a min and max column structrure like
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