Thanks for that...

I've adapted the formula so it looks as follows
=VLOOKUP(B6,PlayerID!$A$5:$D$450,2,FALSE)

B6 is the first cell where i would hope to put the ID thus replacing
the A10 as you have suggested and PlayerID is the name of Sheet2.

Everything else I have left untouched but the formula doesn't seem to
work. Entering the code in B6 and hitting return has no effect and in
cells C6,D6,E6, the formula remains visible and nothing happens when
entering the ID in B6.

Have i changed the formula too much do you think or is there anything
you can see from the above formula that is preventing it from working
correctly?

Thanks again for your time and patience.


--
El Shish
------------------------------------------------------------------------
El Shish's Profile: http://www.excelforum.com/member.php...o&userid=37710
View this thread: http://www.excelforum.com/showthread...hreadid=573007

instead of PlayerID enter the sheet name which contains your data (i-e
sheet1). suppose you have data in sheet named PlayerData and you want
to put Id's in sheet named PlayerID to return the respective info. then
change the function as follows.

=VLOOKUP(B6,*PlayerData!$A$5:$D$450*,2,FALSE)
change bolded range in all formulas (first put correct sheet name
instead of PlayerData)

El Shish Wrote:
Thanks for that...

I've adapted the formula so it looks as follows
=VLOOKUP(B6,PlayerID!$A$5:$D$450,2,FALSE)

B6 is the first cell where i would hope to put the ID thus replacing
the A10 as you have suggested and PlayerID is the name of Sheet2.

Everything else I have left untouched but the formula doesn't seem to
work. Entering the code in B6 and hitting return has no effect and in
cells C6,D6,E6, the formula remains visible and nothing happens when
entering the ID in B6.

Have i changed the formula too much do you think or is there anything
you can see from the above formula that is preventing it from working
correctly?

Thanks again for your time and patience.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=573007

Ok, the ids are being entered into column b starting with b6

C6 contains the following formula
=VLOOKUP(B6,PlayerID!$A$5:$D$450,2,FALSE)
D6 contains the following formula
=VLOOKUP(B6,PlayerID!$A$5:$D$450,3,FALSE)
E6 contains the following formula
=VLOOKUP(B6,PlayerID!$A$5:$D$450,4,FALSE)

The sheet containing the ID and the individual's information is called
PlayerID

Within that sheet A5-A450 contain the player's ID
B5-B450 contain the Player's Surname
C5-D450 contain the Player's First Name
D5-D450 cnntain the Player's Salary

Hopefully this means I have followed your advice correctly but its
still not working and i'm not sure why.

Any ideas?


--
El Shish
------------------------------------------------------------------------
El Shish's Profile: http://www.excelforum.com/member.php...o&userid=37710
View this thread: http://www.excelforum.com/showthread...hreadid=573007

I have attached a sample workbook with these functions implemented and
they work fine.

however attach a sample workbook or send to me for proper
consideration:


El Shish Wrote:
Ok, the ids are being entered into column b starting with b6

C6 contains the following formula
=VLOOKUP(B6,PlayerID!$A$5:$D$450,2,FALSE)
D6 contains the following formula
=VLOOKUP(B6,PlayerID!$A$5:$D$450,3,FALSE)
E6 contains the following formula
=VLOOKUP(B6,PlayerID!$A$5:$D$450,4,FALSE)

The sheet containing the ID and the individual's information is called
PlayerID

Within that sheet A5-A450 contain the player's ID
B5-B450 contain the Player's Surname
C5-D450 contain the Player's First Name
D5-D450 cnntain the Player's Salary

Hopefully this means I have followed your advice correctly but its
still not working and i'm not sure why.

Any ideas?


+-------------------------------------------------------------------+
|Filename: VLOOKUP.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5229 |
+-------------------------------------------------------------------+

--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=573007

Hi,

I've fiddled a little and got the thing working.

Turns out i had it in formula auditing mode.

God, that makes me feel more than a little silly.

Anyhow, thanks very much for your help and time devoted.


--
El Shish
------------------------------------------------------------------------
El Shish's Profile: http://www.excelforum.com/member.php...o&userid=37710
View this thread: http://www.excelforum.com/showthread...hreadid=573007