I am looking for some help to write a formula that will match a text name from sheet (2013 Free Agents Column E) and take the column F Salary and plug it into sheet (2013 Mini-Cap Rosters) Column E under each team name. This is for a football league I run and I have 12 teams. There is an auction that I run for the league and I want the 2013 Mini-Cap Rosters to update "Available FA $" based upon the team that wins the player auction in the 2013 Free Agents sheet and the salary they won the bid at. Below is a link to the google doc spreadsheet to help you understand. Any help is much appreciated.

https://docs.google.com/spreadsheet/...FE&output=html