Hi everyone,
I've been having difficulty with a sheet I've been putting together. Essentially, it is a list of people and their responsibilities VLOOK-ed-UP from another spreadsheet, which in turn is indexed with a multiple result array formula, shown below:
{=IF(ISERROR(INDEX($AA$1:$AC$345,SMALL(IF($AC$1:$AC$345="U",ROW($AC$1:$AC$345)),ROW(1:1)),1)),"",INDEX($AA$1:$AC$345,SMALL(IF($AC$1:$AC$345="U",ROW($AC$1:$AC$345)),ROW(1:1)),1))}
With "U" being the name of the person for whom the results are being returned. This is copied multiple times across the table for different people and ranges, and works just fine, but in two columns, for the same person, the formulas go blank, like there's nothing in the table. I've tried formatting the whole table, all kinds of permutations of testing, but I just can't work out why the same formula, searching the same set of data generated in the same way, would return a negative result.
Any help or suggestions enormously appreciated,
JB
Bookmarks