Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range in another workbook | Excel Programming | |||
Referencing cell in Named Range in Function VS Formula | Excel Programming | |||
Referencing a range within a workbook | Excel Programming | |||
VBA Referencing a Named Cell Range in another Workbook | Excel Programming | |||
Referencing a range from another workbook | Excel Programming |