Im trying to pull all the rows that match a certain criteria. I already have
one of these formulas in place that pulls from another sheet but the range is
1:16200 and it works great. Here's a small quick layout:

NY N Apt
NY N Apt
NY N Off
NY N Off
NY N Ret

where NY is in A98, N in B98 and Apt in C98. I want all the rows that apply
to Apt.

"Bob Phillips" wrote:

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......