Forum Discussion

Anonymous

Nov 04, 2017

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 ot...

team demo.xlsx27 KB

Formulas & Functions

tips and tricks

Anonymous

Dec 15, 2017

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

Anonymous
Dec 18, 2017
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?