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