Multiple corresponding Values (Biff.........)
Having trouble getting this formula to work. Im hoping its just something
small I'm missing.....My info is in A98:AB400 the values I want to evaluate
are in column C.
Here is my current formula:
=INDEX($A98:$AB400,SMALL(IF($C$98:$C$400=H6,ROW($9 8:$400)),ROW(98:98)),1)
I've tried to change the ranges, the rows and everthing else and I still get
error formulas........Please help to end my suffering......
|