especially my help this afternoon <vbg

Bob

"Ribeye" wrote in message
...
GOT IT!!! I just used a IF(ISERROR( and everything seems to be going fine
now. Thanks again for your help.

"Ribeye" wrote:

Bob, I found the problem.......I had some #NUM's after my info so I
think the
formula was looking to that. When I changed the range the formula
worked.
However the range of values will always be changing and I dont want to
have
to change the formula range every time. Is there a way I can get the
formula
to ignore the #NUM??

"Bob Phillips" wrote:

I think that this is what you need


=INDEX($A$98:$AB$400,SMALL(IF($C$98:$C$400=$H$90,R OW($98:$400)),ROW(1:1))-MI
N(ROW($A$98:$A$400))+1,1)

still an array formula

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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