Index and match question

[Med4040]

Hi guys,

I need to find the smallest batch size of a product that is made on particular equipment
So on the right I have Equipment 1 (Cell K4) and on this equipment, Product A and Product are made
What are the smallest batch sizes of these products? The source table is on the left
The results should be 221.4 in M4 and 64.4 in M5 because these are the only batch sizes

Now, on equipment 3 in, there are 2 products A (with different batch sizes), product B and Product D. In this case for the product A, the smallest batch size should be the result, when I select product A.

I made an attempt to do that but I couldn't do it.

Thank you.

 

[Aladin Akyurek]

My sincere apologies Aladin. I didn't pay attention that only a large batch size of product A made on equipment 1
The results are accurate. I really appreciate your help and sorry for the confusion

No problem. You are welcome.

 

[Med4040]

Thanks again Aladin,

So here is the question, the products listed in col H have a designation in col B. On the right where I am showing equipment 1 and the products made on it, which product has designation B.
In the attached image, product C has designation B in col I, so in col N, only N5 will have designation B.

 

[Aladin Akyurek]

@ Med4040

In N4 enter and copy down:

=IF(INDEX($H$4:$H$8,MATCH($K$4,$A$4:$A$8,0))=$L4,INDEX($I$4:$I$8,MATCH($K$4,$A$4:$A$8,0)),"")

Note. Try to post your data in a way that is copiable into Excel. Otherwise, the data your images must be re-typed (There is no joy in that for a helper.).