RANK | TEAM NAME | Played | Points |
1 | TEAM A | 4 | 9 |
2 | TEAM B | 4 | 8 |
3 | TEAM C | 3 | 7 |
4 | TEAM D | 4 | 7 |
<tbody>
</tbody>
TEAM INPUT CELL
TEAM C |
<tbody>
</tbody>
I am looking to try and find the TEAM NAME in the input cell within the range above and replicate the data above for the row above and below returning the following in another location:
Rank | TEAM NAME | Played | Points |
2 | TEAM B | 4 | 8 |
3 | TEAM C | 3 | 7 |
4 | TEAM D | 4 | 7 |
<tbody>
</tbody>
Does anyone have any suggestions?
Thanks