V lookup Help!

[Benforest1]

I am trying to populate sheet 1 with the previous months data from sheet 2.

Basically i have a drop down where projects put there RAG each month. I want Row 19 to use last months data (Sheet 2).

Row C column 12 has the name of the project. Sheet 2, RAG is column C.

I have clipped the example sheets below. I would like a V lookup in Row 10 Column B sheet 1 to pull Project 1s (C3) RAG from last month on sheet 2

Sheet 1 -

Book1
	A	B	C	D	E	F	G
1
2		Programme Tier
3		Programme / Project name	Project 1
4	None	Programme Status
5		Lifecycle Phase
6		None
7		Overall Delivery Confidence	Cost	People	Time	Benefits	Dependencies
8
9		Last Months Delivery Confidence	Last Months Cost	Last Months People	Last Months Time	Last Months Benefits	Last Months Dependencies
10
11
12
Sheet1

Cell Formulas
Range	Formula
A4	A4	=IFNA(VLOOKUP($C3,'[Dev Change Portfolio Commission MASTER.xlsm]ProgStream'!$A:$B,2,FALSE),"None")
B6	B6	=IFNA(VLOOKUP(C3,'[Dev Change Portfolio Commission MASTER.xlsm]ProgStream'!A:B,2,FALSE),"None")

Sheet2 -

Book1
	A	B	C	D
1	Month	Programme/Project	Overall Delivery
2	01/05/2022	Project 1	Amber/Red
3	01/05/2022	Project 2	Amber/Red
4	01/05/2022	Project 3	Amber/Green
5	01/05/2022	Project 4	Amber/Red
6	01/05/2022	Project 5	Amber/Red
7	01/05/2022	Project 6	Green
8	01/05/2022	Project 7	Amber
9	01/05/2022	Project 8	Amber/Green
10	01/05/2022	Project 9	Amber
11	01/05/2022	Project 10	Amber
12	01/05/2022	Project 11	Green
13	01/05/2022	Project 12	Amber/Green
14	01/05/2022	Project 13	Amber/Red
15	01/05/2022	Project 14	Amber
16	01/05/2022	Project 15	Green
17	01/05/2022	Project 16	Amber
18	01/05/2022	Project 17	Amber
19	01/05/2022	Project 18	Amber/Green
20	01/05/2022	Project 19	Amber
21	01/05/2022	Project 20	Amber
22	01/05/2022	Project 21	Amber
23	01/05/2022	Project 22	Amber
24	01/05/2022	Project 23	Amber
25	01/05/2022	Project 24	Amber
26	01/05/2022	Project 25	Amber/Green
27	01/05/2022	Project 26	Amber/Green
28	01/05/2022	Project 27	Red
29	01/05/2022	Project 28	Amber/Red
30	01/05/2022	Project 29	Amber/Green
31	01/05/2022	Project 30	Amber
32	01/05/2022	Project 31	Amber
33	01/05/2022	Project 32	Amber/Red
34
Sheet2

Please Help!

 

[Benforest1]

Ignore the formula, thought i had removed them.