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