Excel Formula use to find earliest date

[MeiChan1314]

I want to find the earliest date from the category (Pull Requisition, Push Requisition, Push Requisition-M and Pull Requisition-M) from sheet 2. If use MINIFS(Sheet 2!Category,Sheet 2!Material,Sheet1!A2,"Pull Requisition"), only will return the earliest date of Pull Requisition, but how can return the earliest date from few Requisition category? Any expert can help or advice what the best formula can do. Thank you so much

Sheet 1
Material	Next Requisition date
VL7623001
TA447915
HP8798005
PS14437

Sheet 2
Material Code	Delivery Date	Category
VL7623001	17-06-21	Pull Requisition
VL7623001	03-08-21	Pull Requisition
HP8798005	06-09-21	Push Requisition
HP8798005	10-10-21	Push Requisition
TA447915	30-07-21	Push Requisition-M
TA447915	01-09-21	Push Requisition
PS14437	01-07-21	Pull Requisition-M
PS14437	23-08-21	Push Requisition
PS14437	30-06-21	PO memo

[#2]

@MeiChan1314 

That is something like

=MIN(MINIFS(minRange,criteriaRange,{"Cat1","Cat2"}))

[#3]

@Sergei Baklan The formula return error or showing too many argument. hmm..not sure where goes wrong. I have screenshot for example and attached the file here.

Basically I want to get the earliest delivery date from category Pull, Push , Push-M that match with the same material code. Would you be able to write the formula in complete again to let me better understand. Appreciated in advance!

[#4]

@MeiChan1314 

in B2

=MINIFS(H$2:H$10, G$2:G$10,A2, I$2:I$10,"<>po memo")

[#5]

seem like exclude POmemo, How about if the category do include In-transit, QM lot...so what will be the best formula to exclude those?

[#6]

@MeiChan1314 

If you are on 365 you may FILTER() dates first and MIN() result.