Thread: return value in adjacent cell different workbook
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don D
 
Posts: n/a
Default 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



Reply With QuoteReply With Quote