Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
External reference not working
(Excel 2003) Using INDEX, SMALL, and ROW functions in a formula per the
examples in artical "How to look up a value in a list and return multiple corresponding values". When I use the example verbatim, everything works fine. But when I change the parameter for the comparison value to retrieve from a different sheet in the same workbook, the formula no longer finds a match. example: =IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$ 10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$ 7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1 )),2)) changed to: =IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=TL! $C$2,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$ B$7,SMALL(IF($A$1:$A$7=TL!$C$2,ROW($A$1:$A$7)),ROW (1:1)),2)) The value in the referenced cell is identical to the value in the local cell, so it should all work, not? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External reference not working? | Excel Discussion (Misc queries) | |||
External Links not working | Excel Discussion (Misc queries) | |||
Working With Pivot Table And External DB | Excel Discussion (Misc queries) | |||
External Links not working | Links and Linking in Excel | |||
External References not working right. | Excel Worksheet Functions |