Try a VLOOKUP or INDEX/MATCH combo.

http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
http://www.ozgrid.com/Excel/left-lookup.htm



--
Regards
Dave Hawley
www.ozgrid.com
"EJ Hill" <EJ wrote in message
...
I am building an Excel to recall stats for TV sports. There are three
workbooks, Home, Away and League. The league sheet has all of last
season's
stats.
In all workbooks the player's name is in column A.

Because each player has different stats based on his position, I want to
select the columns returned based on a text string.

Example: In cell A4 of the home sheet is the name JOE SMITH. In A4 is the
text CB.
In cell B5 is the name JOHN DOE and in B4 the text QB.
For the CB it needs to return stats from column G, H, J and N based on the
player's name. For the QB it needs H, I, J, K, L and M.

Is this possible?