Referencing cell range in another workbook with a formula
Hi
I have the following formula working on a sheet but I am trying to reference the same cell range in another workbook (lookup.xls) in the same folder. How do I change the formula to achieve this please?. =IF(ISERROR(INDEX($A$1:$L$9,SMALL(IF($A$1:$A$9=$A$ 11,ROW($A$1:$A $9)),ROW(1:1)),12)),"",INDEX($A$1:$L$9,SMALL(IF($A $1:$A$9=$A$11,ROW($A $1:$A$9)),ROW(1:1)),12)) Any help is greatly appreciated as I am up against a brick wall on this one Eddie |
Referencing cell range in another workbook with a formula
[WorkbookName]Sheet!Range
=[myWorkbook]Sheet1!$A$1:$D$8 "webels" wrote in message ... Hi I have the following formula working on a sheet but I am trying to reference the same cell range in another workbook (lookup.xls) in the same folder. How do I change the formula to achieve this please?. =IF(ISERROR(INDEX($A$1:$L$9,SMALL(IF($A$1:$A$9=$A$ 11,ROW($A$1:$A $9)),ROW(1:1)),12)),"",INDEX($A$1:$L$9,SMALL(IF($A $1:$A$9=$A$11,ROW($A $1:$A$9)),ROW(1:1)),12)) Any help is greatly appreciated as I am up against a brick wall on this one Eddie |
Referencing cell range in another workbook with a formula
This might be more helpful:
http://www.contextures.com/xlFunctions05.html#RefWkbk "webels" wrote in message ... Hi I have the following formula working on a sheet but I am trying to reference the same cell range in another workbook (lookup.xls) in the same folder. How do I change the formula to achieve this please?. =IF(ISERROR(INDEX($A$1:$L$9,SMALL(IF($A$1:$A$9=$A$ 11,ROW($A$1:$A $9)),ROW(1:1)),12)),"",INDEX($A$1:$L$9,SMALL(IF($A $1:$A$9=$A$11,ROW($A $1:$A$9)),ROW(1:1)),12)) Any help is greatly appreciated as I am up against a brick wall on this one Eddie |
Referencing cell range in another workbook with a formula
On May 3, 6:54*pm, "JLGWhiz" wrote:
This might be more helpful: http://www.contextures.com/xlFunctions05.html#RefWkbk "webels" wrote in message ... Hi I have the following formula working on a sheet but I am trying to reference the same cell range in another workbook (lookup.xls) in the same folder. How do I change the formula to achieve this please?. =IF(ISERROR(INDEX($A$1:$L$9,SMALL(IF($A$1:$A$9=$A$ 11,ROW($A$1:$A $9)),ROW(1:1)),12)),"",INDEX($A$1:$L$9,SMALL(IF($A $1:$A$9=$A$11,ROW($A $1:$A$9)),ROW(1:1)),12)) Any help is greatly appreciated as I am up against a brick wall on this one Eddie Thanks JLGWhiz, will give that a go. Eddie |
Referencing cell range in another workbook with a formula
On May 3, 7:49*pm, webels wrote:
On May 3, 6:54*pm, "JLGWhiz" wrote: This might be more helpful: http://www.contextures.com/xlFunctions05.html#RefWkbk "webels" wrote in message .... Hi I have the following formula working on a sheet but I am trying to reference the same cell range in another workbook (lookup.xls) in the same folder. How do I change the formula to achieve this please?. =IF(ISERROR(INDEX($A$1:$L$9,SMALL(IF($A$1:$A$9=$A$ 11,ROW($A$1:$A $9)),ROW(1:1)),12)),"",INDEX($A$1:$L$9,SMALL(IF($A $1:$A$9=$A$11,ROW($A $1:$A$9)),ROW(1:1)),12)) Any help is greatly appreciated as I am up against a brick wall on this one Eddie Thanks JLGWhiz, will give that a go. Eddie Thanks for your help works perfect now. |
Referencing cell range in another workbook with a formula
Glad it worked for you!
"webels" wrote in message ... On May 3, 7:49 pm, webels wrote: On May 3, 6:54 pm, "JLGWhiz" wrote: This might be more helpful: http://www.contextures.com/xlFunctions05.html#RefWkbk "webels" wrote in message ... Hi I have the following formula working on a sheet but I am trying to reference the same cell range in another workbook (lookup.xls) in the same folder. How do I change the formula to achieve this please?. =IF(ISERROR(INDEX($A$1:$L$9,SMALL(IF($A$1:$A$9=$A$ 11,ROW($A$1:$A $9)),ROW(1:1)),12)),"",INDEX($A$1:$L$9,SMALL(IF($A $1:$A$9=$A$11,ROW($A $1:$A$9)),ROW(1:1)),12)) Any help is greatly appreciated as I am up against a brick wall on this one Eddie Thanks JLGWhiz, will give that a go. Eddie Thanks for your help works perfect now. |
All times are GMT +1. The time now is 10:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com