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 |