most
Board Regular
- Joined
- Feb 22, 2011
- Messages
- 106
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
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>
</tbody>
With
I get these results.
But expected result is that line 1 should have Y_15.
<tbody>
</tbody>
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
ID | Grade |
123456 | |
123456 | Y_15 |
654321 | Y_16 |
654321 |
<tbody>
</tbody>
With
Code:
=VLOOKUP(A2;A:B;2;FALSE)
But expected result is that line 1 should have Y_15.
ID | Grade |
123456 | 0 |
123456 | Y_15 |
654321 | Y_16 |
654321 | Y_16 |
<tbody>
</tbody>