Formula needed to extract a value based off multiple criteria

[ItalianPlatinum]

Hello - Running into a head scratcher here. it seems easy but I am having trouble putting all the pieces together and hoping someone could help. I condensed my large data set into one tab for ease as a sample

1. I have VBA code that will run 1 days worth of data if B11 = B12
2. If B11 doesnt equal B12 then it will run for 2 sets of dates; once for B11 and once for B12. So duplicates will generate.
3. Formula I am looking for is to lookup the price of a identifer where if C is blank it uses B11 as the date to lookup and if C has a value it uses B12 as a lookup

I can rearrange A:D to make the lookup easier. Any help is appreciated my dataset is 1,000 lines so manual approach is exhaustive. I am open for VBA or a formula. Thanks in advance.

Book1
	A	B	C	D	E	F	G	H
1	Date	Price	Fri/Sun	Indentifier		Today's Date	Indentifier	Price
2	30-Oct	10		AAA		30-Oct	AAA	Formula
3	30-Oct	15		BBB		30-Oct	BBB	Formula
4	30-Oct	20	S	CCC		30-Oct	CCC	Formula
5	30-Oct	75	S	DDD		30-Oct	DDD	Formula
6	1-Nov	20	S	CCC
7	1-Nov	75	S	DDD
8	1-Nov	10		AAA
9	1-Nov	15		BBB
10
11	Today's Date	10/30/2020			New Years Day	1/1/2020
12	Last BD - 1 or Holiday adjusted	11/1/2020			Martin Luther King, Jr. Day	1/20/2020
13					Washington's Birthday	2/17/2020
14					Good Friday	4/10/2020
15					Memorial Day	5/25/2020
16					Independence Day	7/3/2020
17					Labor Day	9/7/2020
18					Thanksgiving Day	11/26/2020
19					Christmas Day	12/25/2020
Data

Cell Formulas
Range	Formula
B11	B11	=TODAY()-1
B12	B12	=WORKDAY(TODAY(),1,F11:F19)-1

 

[hnsd24_CN]

test2.xlsx
	A	B	C	D	E	F	G	H
1	Date	Price	Fri/Sun	Indentifier		Today's Date	Indentifier	Price
2	10/30/20	10		AAA		10/30/20	AAA	10
3	10/30/20	15		BBB		10/30/20	BBB	15
4	10/30/20	20	S	CCC		10/30/20	CCC	21
5	10/30/20	75	S	DDD		10/30/20	DDD	76
6	11/01/20	21	S	CCC
7	11/01/20	76	S	DDD
8	11/01/20	11		AAA
9	11/01/20	16		BBB
10
11	Today's Date	10/30/20			New Years Day	1/1/2020
12	Last BD - 1 or Holiday adjusted	11/01/20			Martin Luther King, Jr. Day	1/20/2020
13					Washington's Birthday	2/17/2020
14					Good Friday	4/10/2020
15					Memorial Day	5/25/2020
16					Independence Day	7/3/2020
17					Labor Day	9/7/2020
18					Thanksgiving Day	11/26/2020
19					Christmas Day	12/25/2020
Sheet1

Cell Formulas
Range	Formula
H2:H5	H2	=MAX(IF({1,0},($A$2:$A$9=$B$11)*($D$2:$D$9=G2)*$B$2:$B$9*($C$2:$C$9=""),($A$2:$A$9=$B$12)*($D$2:$D$9=G2)*$B$2:$B$9*($C$2:$C$9<>"")))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[ItalianPlatinum]

test2.xlsx
	A	B	C	D	E	F	G	H
1	Date	Price	Fri/Sun	Indentifier		Today's Date	Indentifier	Price
2	10/30/20	10		AAA		10/30/20	AAA	10
3	10/30/20	15		BBB		10/30/20	BBB	15
4	10/30/20	20	S	CCC		10/30/20	CCC	21
5	10/30/20	75	S	DDD		10/30/20	DDD	76
6	11/01/20	21	S	CCC
7	11/01/20	76	S	DDD
8	11/01/20	11		AAA
9	11/01/20	16		BBB
10
11	Today's Date	10/30/20			New Years Day	1/1/2020
12	Last BD - 1 or Holiday adjusted	11/01/20			Martin Luther King, Jr. Day	1/20/2020
13					Washington's Birthday	2/17/2020
14					Good Friday	4/10/2020
15					Memorial Day	5/25/2020
16					Independence Day	7/3/2020
17					Labor Day	9/7/2020
18					Thanksgiving Day	11/26/2020
19					Christmas Day	12/25/2020
Sheet1

Cell Formulas
Range	Formula
H2:H5	H2	=MAX(IF({1,0},($A$2:$A$9=$B$11)*($D$2:$D$9=G2)*$B$2:$B$9*($C$2:$C$9=""),($A$2:$A$9=$B$12)*($D$2:$D$9=G2)*$B$2:$B$9*($C$2:$C$9<>"")))
Press CTRL+SHIFT+ENTER to enter array formulas.

Thank you i will test it out this week with all the data and see how it works. appreicate it. working on my small sample thus far.