Match-Index Problem?

Hi --

I'm an Excel novice and am not completely sure if this is a match-index problem, but I am trying to call a column of cells that have different teams and place them in the appropriate cells on a different sheet.

The easiest way to understand that is to look at the attached document. The first sheet has the teams in column A and appropriate lanes for each game in columns B-J. This sheet is to give the teams a quick view into where they will be moving after each game. The second sheet is designed to give teams an easy view of who they will be competing against each game. It is this sheet that I am trying to figure out, and I don't know where to start without doing it manually.

I would like to create a formula that calls on the teams and their lanes detailed on the first sheet and automatically inputs them in the appropriate cell on the second sheet. Any ideas? Help would be MUCH appreciated!

Put this formula in cell B2 of the matchups sheet:

Formula:

Please Login or Register  to view this content.

then copy across and down, as in the attached workbook.

Hope this helps.

Pete

Excellent! Thank you so much!