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

[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

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

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

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.

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.