HELP.. can't get my index & match formula to work

[DawnLaGood]

I have two tables. In the first table are the rates by resource (columnA) and the MonthYear (ColumnB-Y)
In another table, table 2, where I have the resource (columnA) date MMDDYYY (columnB).
I need for table 2 to look up and match both the resource and date from table 1 and return the rate where they intersect.

Table 1

Table 2

I've tried everything I can think of but I keep breaking on the date lookup/match. Table 1 only uses month year where table two uses the full date.

Anyone have any suggestions?

 

[AhoyNC]

See if one of these examples helps.
Example 1 assumed your dates in Table 1 are actual dates formatted as mmm-yy
Example 2 assumes your dares in Table 1 are text.

Book3
	A	B	C	D	E	F
1	Example 1
2	If dates in Table 1 are actual dates formated as MMM-YY.
3	Res	Jan-22	Feb-22	Mar-22
4	Doe, John	55.17	55.17	55.17
5	Doe, Jane	25.90	25.90	25.90
6
7	Table2
8	Res	Date		rate
9	Doe, John	2/7/2022		55.17
10	Doe, Jane	3/3/2022		25.9
11
12	Example 2
13	If dates in Table 1 are text
14	Res	Jan-22	Feb-22	Mar-22
15	Doe, John	55.17	55.17	55.17
16	Doe, Jane	25.90	25.90	25.90
17
18
19	Res	Date		rate
20	Doe, John	2/7/2022		55.17
21	Doe, Jane	3/3/2022		25.90
Sheet1

Cell Formulas
Range	Formula
D9:D10	D9	=INDEX($B$4:$D$5,MATCH($A9,$A$4:$A$5,0),MATCH(MONTH($B9)&YEAR($B9),MONTH($B$3:$D$3)&YEAR($B$3:$D$3),0))
D20:D21	D20	=INDEX($B$4:$D$5,MATCH($A20,$A$4:$A$5,0),MATCH(TEXT(B20,"mmm-yy"),$B$14:$D$14,0))

 

[DawnLaGood]

See if one of these examples helps.
Example 1 assumed your dates in Table 1 are actual dates formatted as mmm-yy
Example 2 assumes your dares in Table 1 are text.

Book3
	A	B	C	D	E	F
1	Example 1
2	If dates in Table 1 are actual dates formated as MMM-YY.
3	Res	Jan-22	Feb-22	Mar-22
4	Doe, John	55.17	55.17	55.17
5	Doe, Jane	25.90	25.90	25.90
6
7	Table2
8	Res	Date		rate
9	Doe, John	2/7/2022		55.17
10	Doe, Jane	3/3/2022		25.9
11
12	Example 2
13	If dates in Table 1 are text
14	Res	Jan-22	Feb-22	Mar-22
15	Doe, John	55.17	55.17	55.17
16	Doe, Jane	25.90	25.90	25.90
17
18
19	Res	Date		rate
20	Doe, John	2/7/2022		55.17
21	Doe, Jane	3/3/2022		25.90
Sheet1

Cell Formulas
Range	Formula
D9:D10	D9	=INDEX($B$4:$D$5,MATCH($A9,$A$4:$A$5,0),MATCH(MONTH($B9)&YEAR($B9),MONTH($B$3:$D$3)&YEAR($B$3:$D$3),0))
D20:D21	D20	=INDEX($B$4:$D$5,MATCH($A20,$A$4:$A$5,0),MATCH(TEXT(B20,"mmm-yy"),$B$14:$D$14,0))

omg thank you very much that worked perfect!!!

 

[Peter_SSs]

thank you very much that worked perfect!!!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.