Extract list using minimum as criteria

[pto160]

I have 3 columns- the order number, receipt number and product. I am trying to get the product list based on the order number and minimum of the receipt number. In this case the order number I want is 20000 and the minimum of the receipt number is 100, so the product is dog and cat.
Is there a way to do this?
I have Excel 365.

Book1
	A	B	C
1	Order	Receipt	Product
2	20000	200	dog
3	20000	200	cat
4	20000	200	house
5	20000	100	dog
6	20000	100	cat
7	30000	300	table
8	30000	300	chair
9
10
11	Result I would Like		Criteria: is Order 20000 and the mininum of the receipt number which is 100
12	Dog
13	Cat
Sheet1

 

[Joe4]

Try this formula:

=FILTER(C2:C8,(A2:A8=20000)*(B2:B8=MIN(B2:B8)))

 

[RoryA]

I suspect you want the minimum receipt number for that order, so try a small change to Joe's formula:

=FILTER(C2:C8,(A2:A8=20000)*(B2:B8=MINIFS(B2:B8,A2:A8,20000)))

 

[Joe4]

I suspect you want the minimum receipt number for that order, so try a small change to Joe's formula:

=FILTER(C2:C8,(A2:A8=20000)*(B2:B8=MINIFS(B2:B8,A2:A8,20000)))

Oh! Good point Rory!

It worked out for the particular example because the minimum value just happens to be with the column A values they are looking for, but that may not always be the case!

 

[pto160]

Yes, my apologies, Yes, I wanted the minimum receipt number for that order.
Thank you so much to everyone. The solutions work great.

 

[Joe4]

Yes, my apologies, Yes, I wanted the minimum receipt number for that order.
Thank you so much to everyone. The solutions work great.

I know what you meant, the formula I created just didn't quite do all of that, so would work in some instances but not all.
Luckily, Rory was able to add the missing piece!

 

[pto160]

Thanks Joe4 for the clarification and help.

 

[Joe4]

You are welcome.
Glad we were able to help.
It was truly a team effort!