Sumifs with Vlookup?

[MGCC]

I've searched the internet far and wide for an answer to this question with no success. I'm hoping the brilliant minds in this forum can be of assistance.

From	To	Mon	Tue	Wed	Thu	Fri	Sat	Sun
4/1/2023	4/30/2023	139	152	152	152	180	199	139
5/1/2023	5/31/2023	169	183	183	183	205	230	169
6/1/2023	6/30/2023	179	309	309	309	232	252	179
7/1/2023	7/31/2023	192	215	215	215	245	265	192
8/1/2023	8/31/2023	273	276	276	276	315	335	273
9/1/2023	9/30/2023	185	209	209	209	239	252	185
10/1/2023	10/31/2023	142	167	167	167	189	209	142
11/1/2023	11/30/2023	139	152	152	152	180	199	139

I need a formula which will return the value based on multiple criteria.
E.g. If i want to know what is the rate for 04/07/23 which is Friday, i would need a formula to recognize that this day is Friday and return the value of 180 but I need the same formula to give me rate for 07/13 (Thursday) and return the value of 215.

Any help with this would be a greatly appreciated.

 

[Legacy 143009]

For the following setup your formula will be:

=VLOOKUP(B11,$A$2:$I$9,MATCH(TEXT(B11,"ddd"),$A$1:$I$1,0),1)

 

[MGCC]

Amazing. Thank you

 

[Legacy 143009]

I am glad it did help! Thanks for the feedback