Indexing/Match Question

[daydro]

Here is a screenshot (Image 1) of the information I want to pull. There are up to 30 of these tables at any given time. All have different information. I am trying to figure out a way to first find the team, then find the player on that team and then return the pos (PG,SG,SF,PF,C) to another sheet where I am collecting all the data. On the other sheet (Image 2), I have the search criteria. So I want to search O3 to find the team table in A:A, then search B3 in B:B to find the player, then return the position next to the player name in C:C. I have tried but keep getting errors and I feel like I'm just spinning my wheels at this point. Any help would be appreciated!


Image 1

Image 2:

 

[AlanY]

if you don't have players with identical name you can just use a simple index/match, such as

=index(C:C, match(B3,B:B,0))