Excel Question Please Help

[Guest]

I have a document used for running a golf tour, I have 2 tabs along the
bottom. The first tab is used to list all of the Tour Members and give them
a number. Then for each event which is the second page it should call all of
that information just from the number used on the left side. I need it to be
in any order and right now I have it working only if it calls in the same
location as the Tour Members Tab. Please help, thanks.
If someone can help I'll send the excel document to you in a email, thanks.

 

[JulieD]

Hi

would have been useful if you had provided the formula that you use on the
second tab ... but if it's a VLOOKUP formula then put 0 in the fourth
parameter
eg.
=VLOOKUP(A2,'Tour Members'!$A$2:$C$100,3,0)

Cheers
JulieD

 

[Gordon]

Hi

would have been useful if you had provided the formula that you use
on the second tab ... but if it's a VLOOKUP formula then put 0 in the
fourth parameter
eg.
=VLOOKUP(A2,'Tour Members'!$A$2:$C$100,3,0)

Cheers
JulieD

What's the difference (if any) between using 0 and "false"?

 

[Dave Peterson]

Nothing in this case.

(or just the spelling <vbg>.)