VALUE error with index(row.. match(true.. >row..

[Guest]

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(TRUE,$AB$1148:$AB$1241=$AB9,0))>ROW($A$1148))

 

[Guest]

Did you enter the formula with Cntrl+Shift+Enter (which is necessary for
array formulas)? Click on your formula, hit F2, and then CSE. If that
doesn't work, post additional details about your data and what you are trying
to do.

 

[Guest]

hi, thanks.. missed that during testing externally, from cond. format.. but
other problem (same? prob) is in cond. format, item works by itself, but when
included in an "OR" / with another condition, the first item that normally
works, is somehow negated / does not work.

=IF(ROW($A9)>ROW($A$1151),"",OR(ISNUMBER(SEARCH("
",A9)),INDEX(ROW($AB$1151:$AB$1249),MATCH(TRUE,$AB$1151:$AB$1249=$AB9,0))>ROW($A$1151)))

if any curious, purpose is to highlight any names ab9.. are the same in a
"No" list located after row 1151, makes a hilite; "or isnumber search for
empty space's" is the 1st item that does not work simulaneously with the
index search. thanks
- minor item, don't waste alot of time with.