return value in adjacent cell different workbook
 

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

return value in adjacent cell different workbook
 

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

HTH
--
AP
"Don D" <Don a écrit dans le message de news:
...
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

return value in adjacent cell different workbook
 

Ooops:
=VLOOKUP(B2,Sheet1:A$2:B$4,2,0)

Cheers,
--
AP

"Don D" <Don a écrit dans le message de news:
...
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

return value in adjacent cell different workbook
 

I tried this and got #name?

"Ardus Petus" wrote:

Ooops:
=VLOOKUP(B2,Sheet1:A$2:B$4,2,0)

Cheers,
--
AP

"Don D" <Don a écrit dans le message de news:
...
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

return value in adjacent cell different workbook
 

Got it to work Thanks a bunch

"Don D" wrote:

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