Good morning.

In all my years, Ive not come across this. Searched the Board; theres a
post suggesting drop-down lists, but that would require too much ongoing
manual input (I think).

1) I have 2 criteria that must be met
2) I have a table of data that includes many rows of data that will meet the
criteria, many that will not.

How do I get Excel to extract all correct answers? The problem, as I see it,
is that I input my request for this in one cell, thus limiting myself to one
answer. Im not so sure the answer is to copy that static criteria down a
bunch in one column, and then do a V-Lookup, because there are multiple
unique 2-criteria data sets with corresponding multiple possible returns.
That means Id have to copy a bunch of different 2-criteria data sets and
V-Lookups (hundreds).

Do I finally have a reason to learn Access? I have Excel 00, 03, and 07.

I sense Im gonna learn something new today. Thanks!