Excel formula - week number & day criteria outputs date

[kets23]

Hi

I'm after a formula that looks at a sheet (2nd table below), to display contents in Column G in the table below:

	A	B	C	D	E	F	G
	Name	Subject	Room	Time	Week Number	Day
1	R Jones	Maths	B12	09:00 – 11:00	1	Tuesday
2	T Wells	Science	B13	10:00 – 12:00	4	Friday
3	C Smith	History	B14	14:00 – 15:00	5	Wednesday
4	E Taylor	Geography	B15	11:00 – 12:00	6	Monday
5	B Leys	English	B16	13:00 – 14:30	8	Monday

<tbody>
</tbody>

In the example above, the formula would look at Column E week number 5 & Column F which is a Wednesday. The source data for this would be on a separate sheet (second table below) and the output I want to display in column G would be 24/10/2018.
I’m guessing I would need a Vlookup that looks at 2 criteria’s from the table below to display the output in column G but not sure how to construct this.

Any suggestions would be grateful.

Thanks

		A	B	C	D	E
	Week	Monday	Tuesday	Wednesday	Thursday	Friday
1	1	24/09/2018	25/09/2018	26/09/2018	27/09/2018	28/09/2018
2	2	01/10/2018	02/10/2018	03/10/2018	04/10/2018	05/10/2018
3	3	08/10/2018	09/10/2018	10/10/2018	11/10/2018	12/10/2018
4	4	15/10/2018	16/10/2018	17/10/2018	18/10/2018	19/10/2018
5	5	22/10/2018	23/10/2018	24/10/2018	25/10/2018	26/10/2018
6	6	29/10/2018	30/10/2018	31/10/2018	01/11/2018	02/11/2018
7	7	05/11/2018	06/11/2018	07/11/2018	08/11/2018	09/11/2018
8	8	12/11/2018	13/11/2018	14/11/2018	15/11/2018	16/11/2018
9	9	19/11/2018	20/11/2018	21/11/2018	22/11/2018	23/11/2018
10	10	26/11/2018	27/11/2018	28/11/2018	29/11/2018	30/11/2018
11	11	03/12/2018	04/12/2018	05/12/2018	06/12/2018	07/12/2018
12	12	10/12/2018	11/12/2018	12/12/2018	13/12/2018	14/12/2018

<tbody>
</tbody>

 

[AlphaFrog]

This will calculate the date based on the DateValue as week 1. You could reference a cell with the week1 date instead of using DateValue.

=DATEVALUE("24/09/2018")+((E2-1)*7)+MATCH(F2,{"Monday","Tuesday","Wednesday","Thursday","Friday"},0)-1