My source table is actually in a separate worksheet and I am using a named
cell to populate the Match criteria, so a sort of form. AutoFilter would
still be a bit complicated due to the number of unique "categories" assorted
with Column A - Colors.
--
Archie


"Teethless mama" wrote:

How about Auto Filter


"Archie999" wrote:

I have a small table similar to the following:
Color Object
A B
1 Green Apple
2 Yellow Banana
3 Red Stop Sign
4 Green Grass

=INDEX(A1:B4,MATCH("Green",A1:A4,0),2) -- (Apple)
INDEX/MATCH formula works perfectly to obtain the first matching record, but
how can I create a list (each matching item in its own cell in a column) of
all matching records, ie all objects that are Green. Is there some sort of
Exclude function that will allow me to use the same formula without producing
the same result as the cell above it? A Pivot Table is overkill for what I
am trying to do.
--
Archie