Formula to extract values based on criteria

[excelos]

Hello!

I have data in three columns: A,B,C and each columns has several rows with numbers.

I want to return all the A numbers that match:

B= 4 or 3
AND
C = 5

Any idea?

I have been browsing through several websites but most at horrible in explaining bit by bit the formulas.

Thanks!

 

[DanteAmor]

You could give some examples of what you have and also show the expected result.

 

[James006]

Thanks for the specific example ...

https://www.mrexcel.com/forum/excel...tches-based-several-criteria.html#post5248633

=IF(B2:B10=3,IF(C2:C10=5,A2:A10))+IF(B2:B10=4,IF(C2:C10=5,A2:A10))

 

[jmacleary]

Can't you accomplish this using filters? Set the custom filter for column B to be 4 or 3 and the filter for column C to 5. Once filtered you can copy/paste the data or do whatever else you want to do with it.

 

[DanteAmor]

 

[excelos]

Thanks for the specific example ...

https://www.mrexcel.com/forum/excel...tches-based-several-criteria.html#post5248633

=IF(B2:B10=3,IF(C2:C10=5,A2:A10))+IF(B2:B10=4,IF(C2:C10=5,A2:A10))

Thanks!
Will this return the whole array so that I can feed it in a SMALL formula to extract the nth values?

 

[James006]

Thanks!

Will this return the whole array so that I can feed it in a SMALL formula to extract the nth values?

You are welcome ...

To answer your question : Yes ... absolutely ...

 

[James006]

Just out of curiosity ...

Have you carried out your own tests ... ???

 

[excelos]

Yes I am working on it.
But it is confusing that formulas can return a single reference or a range (array).
Which formulas are these?
I never expected that the IF formula can return an array.

 

[James006]

Feel free to share your obstacles and progress in dealing with array formulas ...