ExcelBanter - HLOOKUP into another xls file

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HLOOKUP into another xls file (https://www.excelbanter.com/excel-worksheet-functions/259575-hlookup-into-another-xls-file.html)

Paul Dennis

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

Max

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

All times are GMT +1. The time now is 09:00 PM.