2 Values Compared to 2 Values = Text

[Roger Hendrix]

Good afternoon. I have been struggling with a formula. There seems to be touches on my particular situation all over the net, but not a specific answer.

Scenario: I have a NCAA Basketball Tournament Bracket that is fairly "smart". My bracket currently uses =VLOOKUP(C6,'Historical Season Stats'!A3:D153,4,0). Once i type in the team name in the position of the bracket it will auto fill the win loss stats above the name of the team.

I would like to be able to just type in the information on the Historical Season Stats sheet and have it auto fill the information for the team as well as the stats. My columns on the data sheet are : Team Name, Division, Seed, Season (W-L).

I have been playing with index / match with no luck. The struggle is each bracket has seeded positions of 1 thru 16 with four different brackets being South, East, West, and Midwest.

Would array work somehow to make it so i could only enter the data one time?

Thanks for taking a look.

 

[lepage0]

You need to be more specific. How do your brackets work? where is all the Raw data stored? you could simply store all the data for each team on a hidden tab and run a array index match formula. Please give an example as I am trying to understand what you are trying to do. What information do you type in the historical season stats sheet?