Prev: multiple correlations with one click?
Next: Is this an Index/Match formula?
From: Paul Dennis on 22 Mar 2010 12:34
=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
From: Max on 23 Mar 2010 09:24
Try Edit>Replace/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
 | 
Pages: 1
Prev: multiple correlations with one click?
Next: Is this an Index/Match formula?