How return multple text after multiple condition met?

[smf97]

Capture.PNG

I want to find out what company bought "chick-01" with their status on "RUN".

I want my excel to return company name "DEX" and "TARCH" as they bought chick-01 and thier status is RUN.

Thank you!

[alansidman]

Here is a VBA solution for you

Please Login or Register  to view this content.

[José Augusto]

Hi

Try this two solutions:

Use in Q3 and R3 your filter, respectively 'CHICK-01' and 'RUN'

First solution
Use in A7 the following formula (drag down)

Please Login or Register  to view this content.

Second solution
Use advanced filters. To do that you must transpose your data to (J1:M6) and use P2:S_n to update filter options.
See the image Advanced filter.PNG

See the file to clarify.