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