Forum Discussion
Solved
Mirroring Cells
I want each player's average ranking to show up underneath "Positional Tiers" in addition to Column O. The order of players will be changing a lot, so A2-O2 could swap with A4-O4, etc. If I set Cell ...
- This would be a perfect situation for a lookup. If you have office 365, try using XLOOKUP, something in X3 would be =XLOOKUP(W3,A:A,O:O). This searches for whatever is next to it, finds it in column A, then returns whatever is in that same row in column O. Vlookup will be a similar function, should be easy to convert if you're running and older version.
This would be a perfect situation for a lookup. If you have office 365, try using XLOOKUP, something in X3 would be =XLOOKUP(W3,A:A,O:O). This searches for whatever is next to it, finds it in column A, then returns whatever is in that same row in column O. Vlookup will be a similar function, should be easy to convert if you're running and older version.