Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ISNA with Index
Hello all,
Can you add a ISNA in a index match formula? I try to put it in the formula but it did not like it. {=INDEX('101408'!$T$2:$T$2491,MATCH(1,(M2='101408' !$R$2:$R$2491)*(I2='101408'!$S$2:$S$2491),0))} Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF(ISNA.... | Excel Discussion (Misc queries) | |||
IF ISNA Help | Excel Discussion (Misc queries) | |||
ISNA help | Excel Worksheet Functions | |||
Using ISNA with OR | Excel Worksheet Functions | |||
ISNA | Excel Worksheet Functions |