Index and match min to max based on two criterias

[mychi11]

artrecordsheet210520202.xlsm
	C	D	E	F	G						M									V								AD	AE
1	CY NO (1)	CY NO (2)	CY NO (3)	WIFE NAME	ART NO.						AVAILABLE EMB									AVAILABLE OC								STRAW BALANCE	LOCATION
2																													A-1C-1
3	6	8		BETTY	200522-01															18								6	A-1C-2
4																													A-1C-3
5	2			ALICE	200514-02						2																	1	A-1C-4
6	1			AMY	200514-01																							11	A-1C-5
7																													A-1C-6
8	3	4	5	ACE	200515-01						2																	1	A-1C-7
9																													A-1C-8
10																													A-1C-9
11	6	8		BETTY	200522-01						2																	1	A-1C-10
12																													A-1C-11
13	1			AMY	200514-01																								A-1C-12
STORAGE TANK

artrecordsheet210520202.xlsm
	A	B	C	D	E	F
1	CY NO.	WIFE NAME	ART NO.	CRYO DATE	LOCATION	LOCATION 2
2	1	AMY	200514-01	19-5-2020	0	0
3	2	ALICE	200514-02	21-5-2020	A-1C-4	0
4	3	ACE	200515-01	18-5-2020	A-1C-7	0
5	4	ACE	200515-01	26-6-2020	A-1C-7	0
6	5	ACE	200515-01	27-8-2020	A-1C-7	0
7	6	BETTY	200522-01	28-5-2020	A-1C-2	0
8	7
9	8	BETTY	200522-01	15-8-2020	A-1C-2	0
10	9	AMY	200514-01	27-5-2020	A-1C-5	A-1C-12
11	10	BETTY	200522-01	4-12-2021	A-1C-10
12	11
13	12
14	13
15	14
16	15
17	16
18	17
19	18
20	19
CY NO

I was having problem to show the cy no for betty and amy correctly. I will need them to match according to the location in this. I am wondering if anyone could suggest me a formula for column C to E in this case?

 

[jasonb75]

Reported as duplicate

index match array formula based on two criteria and from earliest to latest date

CDEFGHNWAEAF1CY NO (1)CY NO (2)CY NO (3) CRYO DATE WIFE NAMEART NO. AVAILABLE EMBAVAILABLE OCSTRAW BALANCE...

www.mrexcel.com

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).