I think the problem is in the Row(98:98), which is looking for the 98th
smallest value, which seems unlikely.

What exactly are you trying to do?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ribeye" wrote in message
...
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......