Saturday, April 1, 2017

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   Apr-01-2017
question by Toby Jacobs:!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. 

And here's the same thing copied:
Round 1Round 2Round 3Round 4Round 5
Player 1Player 9Player 11Player 12Player 14
Player 5Player 10Player 4Player 6Player 15
Player 7Player 3Player 8Player 2Player 13
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!