Hello,
I need help with solving this issue, I want to find and fill data from another row and paste into same column.
I thought VLOOKUP could solve it, but it only works "down", not "up".
Orginal data looks like these
<tbody>
ID
Grade
123456
123456
Y_15
654321
Y_16
654321
</tbody>...