Index match with many criterias- really need help

[duonghientan]

Hi all,

I am trying to use an array formula in order to extract a list of required "Coil No." from Column B. The matter is I not only got 1 criteria but a list of criterias in column N
pic 1.png

Before, I've used Index to take out the "Coil No." that match to criteria "0.12"(Coil Output) and got a list in column N. Then, I have to take out the rest of "Coil.No" in column B that match to single coil number in column N( but their output are not 0.12).

This one is my first task of intership.I do really appreciate all of your concern as well as support.

P/s: Since English is not my mother language, please feel free to ask me again whether there is something you could not get my point

[olwy]

Hi, can you try to put to an excel, what you want to receive? Your description is quite confusing.
Highlight which data you have on beginning, which you should have at the end.

[duonghientan]

Dear olwy,

Please take a look at my attached picture here pic 2.png

Let say I got "Coil No. MF 3443 200" in column N which output is "0.12". Now, see on the Column B, there is another "Coil No. MF 3443 200" that output is not "0.12". I wanna take it out and list it in another column.

Many thanks for your concern, olwy ! Hope my description is clear enough

[olwy]

Not clear enough. So if a combination of B15 and C 15 is not in the same as listed in N + O, you need to get it elsewhere or in N + O column?
I assume, you can use concatenate function and vlookup + filter it, or find a solution via VBA.

How often your A:I data will change?
Am I going on right path?

[duonghientan]

To olwy,

Simply say, we'd better ignore the others, just focus on column B and N. There are some matches between them, i wanna take out all cells in column B which match with any cell in column N, and list them in a new column.

Again, I do really appreciate your concern!

[olwy]

Hi, I am guessing the solution as I still did not get your demand. If you have in your column col + output a combination which is not in a list on the right side, you need to select it. Right?
Here you have it.
solve 3.xlsx

[duonghientan]

To olwy,

Actually its not exactly what I've asked before. But from your guide, I've already firgured out what I need to do(u may see it in attached file below). Thousand thanks to you !

[olwy]

It is even easier, than I though. Happy you have it.
You can give me a reputation star if you would like to...
Have a nice day.