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.
sounds like you want XLOOKUP (or VLOOKUP or INDEX(MATCH()) combo). So in X3:
=XLOOKUP($W$3:$W$21,$A$2:$A$100,$O$2:$O$100)
you may need to adjust the ranges and note the $W$3:$W$21 is a dynamic array that should fill the whole column down in 1 formula instead of only using W3 and then filling down.
=XLOOKUP($W$3:$W$21,$A$2:$A$100,$O$2:$O$100)
you may need to adjust the ranges and note the $W$3:$W$21 is a dynamic array that should fill the whole column down in 1 formula instead of only using W3 and then filling down.