yogi_From A Table Of Rounds And Players Pull Round Each Player is In

Google Spreadsheet   Post  #2142

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-01-2017

question by Toby Jacobs:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/IDdFPhXrARg;context-place=forum/docs

Google Sheets - Use VLookup/Index-Match to look in array for value

Hi all - 

I'm working on using Google Sheets to create draft software for a recreational sports league. I'm trying to use index/match on an array to do a number of things in the software. I did this in Excel a few years back but can't figure out how to get it to work in Google Sheets. 

Example: https://docs.google.com/spreadsheets/d/1Ajq-4zcd0ed3JrBo99Y27r8mVVh1pE7yrjfez1qwfYs/edit?usp=sharing

And here's the same thing copied:

Round 1	Round 2	Round 3	Round 4	Round 5
Player 1	Player 9	Player 11	Player 12	Player 14
Player 5	Player 10	Player 4	Player 6	Player 15
Player 7	Player 3	Player 8	Player 2	Player 13
	Round?
Player 1
Player 2
Player 3
Player 4
Player 5
Player 6
Player 7
Player 8
Player 9
Player 10
Player 11
Player 12
Player 13
Player 14
Player 15

I would like to populate Round? (B7:B21) with a formula that looks for the player name (A7:A21) in the array (A2:E4) and returns the Round (A1:E1).

Any ideas welcome. Thanks!