I will point you to a valuable source of assistance on the VLOOKUP function and
examples of its use.

Debra Dalgleish has instructions, examples and downloadable workbook.

http://www.contextures.on.ca/xlFunctions02.html

You may also want to explore the use of Data Validation drop-down list to pick
your item from.

http://www.contextures.on.ca/xlDataVal01.html



Gord Dibben MS Excel MVP


On Wed, 19 Jul 2006 08:06:02 -0700, B''s Space
wrote:

Hi hardy

Yes, that is exactly what I want... Hope someone out there can come to our
rescue.
Thanks for making it clearer.

B's Space

"hardyz2" wrote:


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