software

working in one workbook and have peoples names. I want to return their
handicaps for their golf scores in another sheet that matches their name. All
are in adjacent columns.
Sheet 1 sheet 2
Names HKP col a col b
bob 7 HKP Name
bill 3 ? joe
joe 4 ? bob
? bill

=VLOOKUP(B2,Sheet1:A2:B4,2,0)

HTH
--
AP
quot;Don Dquot; lt;Don gt; a écrit dans le message de news:
...
gt; working in one workbook and have peoples names. I want to return their
gt; handicaps for their golf scores in another sheet that matches their name.
gt; All
gt; are in adjacent columns.
gt; Sheet 1 sheet 2
gt; Names HKP col a col b
gt; bob 7 HKP Name
gt; bill 3 ? joe
gt; joe 4 ? bob
gt; ? bill
Ooops:
=VLOOKUP(B2,Sheet1:A$2:B$4,2,0)

Cheers,
--
AP

quot;Don Dquot; lt;Don gt; a écrit dans le message de news:
...
gt; working in one workbook and have peoples names. I want to return their
gt; handicaps for their golf scores in another sheet that matches their name.
gt; All
gt; are in adjacent columns.
gt; Sheet 1 sheet 2
gt; Names HKP col a col b
gt; bob 7 HKP Name
gt; bill 3 ? joe
gt; joe 4 ? bob
gt; ? bill
I tried this and got #name?

quot;Ardus Petusquot; wrote:

gt; Ooops:
gt; =VLOOKUP(B2,Sheet1:A$2:B$4,2,0)
gt;
gt; Cheers,
gt; --
gt; AP
gt;
gt; quot;Don Dquot; lt;Don gt; a écrit dans le message de news:
gt; ...
gt; gt; working in one workbook and have peoples names. I want to return their
gt; gt; handicaps for their golf scores in another sheet that matches their name.
gt; gt; All
gt; gt; are in adjacent columns.
gt; gt; Sheet 1 sheet 2
gt; gt; Names HKP col a col b
gt; gt; bob 7 HKP Name
gt; gt; bill 3 ? joe
gt; gt; joe 4 ? bob
gt; gt; ? bill
gt;
gt;
gt;

Got it to work Thanks a bunch

quot;Don Dquot; wrote:

gt; working in one workbook and have peoples names. I want to return their
gt; handicaps for their golf scores in another sheet that matches their name. All
gt; are in adjacent columns.
gt; Sheet 1 sheet 2
gt; Names HKP col a col b
gt; bob 7 HKP Name
gt; bill 3 ? joe
gt; joe 4 ? bob
gt; ? bill