Hi mate,

Sorry to jump on your thread but I am after the same thing.
Basically I run a Fantasy football league and have a spreadsheet for
people to choose there teams.
When they select a player from a list in column A (player name) I would
like their club and value to appear in columns B & C without them having
to select them separately

Example:
Cech - Chelsea - 4.8 (when they select Cech, Chelsea & 4.8 appear in
cells B & C)

Thanks to anyone that can help.


--
hardyz2
------------------------------------------------------------------------
hardyz2's Profile: http://www.excelforum.com/member.php...o&userid=36534
View this thread: http://www.excelforum.com/showthread...hreadid=562807