| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select cell value based on value in adjacent cell | Excel Worksheet Functions | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Reading Data from another workbook... depending on variable in a cell? | Excel Discussion (Misc queries) | |||
| How copy cell workbook to workbook? | Excel Discussion (Misc queries) | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
Linear Mode
