| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLOOKUP into another xls file
=HLOOKUP(Summary!F7,'[CPW(IBM) SD Weekly Report Week 43.xls]Wk43'!$N$3:$S$3,1)
The above works, however sheet which is WK43 in this example and the workbook changes everyweek hence I need to change these values. The workbook name will be in C2 and the worksheet will be in D2, however when I try to build the function I keep getting syntax errors - any ideas - thx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HLOOKUP into another xls file
Try EditReplace/Replace All
-- Max Singapore --- "Paul Dennis" wrote: =HLOOKUP(Summary!F7,'[CPW(IBM) SD Weekly Report Week 43.xls]Wk43'!$N$3:$S$3,1) The above works, however sheet which is WK43 in this example and the workbook changes everyweek hence I need to change these values. The workbook name will be in C2 and the worksheet will be in D2, however when I try to build the function I keep getting syntax errors - any ideas - thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hlookup | Excel Worksheet Functions | |||
| Hlookup? | Excel Worksheet Functions | |||
| can i use hlookup to find data in another file | Excel Discussion (Misc queries) | |||
| hlookup & ? | Excel Worksheet Functions | |||
| hlookup #N/A | Excel Worksheet Functions | |||
Linear Mode
