| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VALUE error with index(row.. match(true.. row..
hi, not sure how to setup formula to work. Tried using IF(ISNA variations,
unsuccessful. not sure how to fix value error. thanks. =IF(A9="","",INDEX(ROW($AB$1148:$AB$1241),MATCH(TR UE,$AB$1148:$AB$1241=$AB9,0))ROW($A$1148)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error suppressing with INDEX/MATCH | Excel Worksheet Functions | |||
| INDEX/MATCH/LARGE returning #VALUE! error | Excel Worksheet Functions | |||
| VLOOKUP, INDEX & MATCH ERROR HELP | Excel Worksheet Functions | |||
| #num Error index, match | Excel Worksheet Functions | |||
| Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions | |||
Threaded Mode
