Vlookup isn't the right function, tried MATCH as well

I am hoping for formula help but VLookup isn't the function for me. I'm pretty new to Excel 2010.
Attached doc is for calculating results from a tournament.
Game scores entered on "Results" Tab.
Each team plays 3 games and could be Home or Visitor.
I would like to know if a formula can transpose game scores from Results tab to Calculations tab for each team/game.
Normally, I have someone read the scores and I enter manually.
I have entered links on the Calculations tab, for results from all games played by the Angry Flyers so you can get the idea.
I have formulas that determine the "Win" and conditional formatting to highlight a Win. Loss = 0.
# of wins, losses, total goals for & against and differential are all formulas.

Can a formula look at Results and place the appropriate Goals for and Goals Against in the appropriate cell for each game? The challenge being each team plays 3 games and could be either home or away.

Lastly, after all scores are entered. A custom sort is performed to determine the highest place team. I would like to know if a custom sort can be saved. But I will post that question later.
Thanks for the assistance!
NS ROXX

Hi
This is array formula. Hit Ctrl+Shift+Enter while enterin formula.
=IF(C$2="Win",--(D3>E3),
INDEX(IF(Calculations!C$2="Goals For",RESULTS!$C$3:$C$100,RESULTS!$F$3:$F$100),SMALL(IF(ISERROR(SEARCH($B3,RESULTS!$B$3:$B$100&RESULTS!$E$3:$E$100)),"",ROW(RESULTS!$B$3:$B$100)-2),COUNTIF(Calculations!$C$2:C$2,Calculations!C$2))))

Paste this to c3 cell and drag it right and down