Can you not do that with two vlookups?

OJ

Hi,

Try this from the experts..
http://www.mvps.org/dmcritchie/excel/vlookup.htm

OJ

I was told how to get a textbox to lookup a corresponding number and show
details relating to that particular number but how do I get a macro to
transfer information from one spreadsheet to another using the corresponding
number.
For example

I have player reg # 44 who score 2000

this will goto sheet2

I want a macro to look at a the players number in column "a" and then look
on sheet 1 for the same number and add the 2 totals together and update
sheet 1 with the details

Any help would be appreciated

Greg

Is there any site anyone could tell me where I can actually read up on the
vlookup rule?

I can't seem to get the idea of it

Thanks in advance

Greg

Thanks OJ