Forum Discussion
Is there a way to do a two way lookup between worksheets?
I'll try to make this simple and I posted a sample file.
I have two worksheets.
One has my rosters with names, numbers, and each team (offense, defense, Kick off, kick off return, etc)
The other has each team laid out in a grid,
I would like to be able to go into the cell for a certain player and team. For example player Joe Cool #25 team offense and type in X and have it put Joe Cool #25 in the X position on the team worksheet
I think I could do this with a vlookup or match index function in the team worksheet cells.
I would also like to be able to type in 25 in the X position on the team worksheet and have it change to Joe Cool #25 and put and X in cell that relates to Joe Cool #25 in the Offense Column on the roster worksheet. I think I could do this with a vlookup function in the roster worksheet cells.
But I want to have this work both ways. Is this possible and if so what function should I use?
3 Replies
Just to be sure, I'd like to clarify your columns.
Is this what you mean?
Worksheet 1:
Names | Numbers | Team Role
_________________________________
Michael Oher | 73 | Offensive Tackle
Worksheet 2:
Team | Team Role | Player
_________________________________________
Baltimore Ravens| Offensive Tackle | Michael Oher
Worksheet one:
Worksheet 1:
Names | Numbers | Offensive Role | Defensive Role | Kickoff Role | Kickoff return Role| Punt Role | Punt Return Role| PAT Role |
_________________________________
Michael Oher | 73 | Offensive Left Tackle | | | | | | PAT Team Right Guard |
Worksheet 2:
Has each of the teams/roles laid out like they line up
Offensive
Defensive
Kickoff
Kickoff return
Punt
Punt Return
PAT
So for Offense in the Left Tackle Position you would find: Michael Oher 73
And for the PAT in the Right Guard Position you would find: Michael Oher 73
Does that make sense?