S
sam
Good morning.
In all my years, I’ve not come across this. Searched the Board; there’s 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. I’m 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 I’d 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 I’m gonna learn something new today. Thanks!
In all my years, I’ve not come across this. Searched the Board; there’s 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. I’m 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 I’d 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 I’m gonna learn something new today. Thanks!