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