Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with indirect
i am trying to use indirect to look up another workbook to see whether or not
the cell is blank and hence the ISBLANK. This formula works but i can not fill it across or down as this cell (D5) remains constant. IF(ISBLANK(INDIRECT("'["&$A$3&" "&$I$1&".xls]other'!D5")),sheet1!D4,"") any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with using INDIRECT with SUMPRODUCT and ROW() | Excel Worksheet Functions | |||
Indirect Formula Problem | Excel Worksheet Functions | |||
problem using the INDIRECT function | Excel Discussion (Misc queries) | |||
Indirect problem | Excel Discussion (Misc queries) | |||
INDIRECT Problem | Excel Discussion (Misc queries) |