VBA help on IF, Index and Match

[azzab13]

Hi Guys and Girls,

I have two worksheets (see below), the first contains all the data and the second sheet acts as a sort of form for entering changes onto the first sheet.

Basically on the second sheet after I have put in the proposed number and selected yes in column "F" I want it to copy the figure onto the first sheet.

For example, if I change the value E2 on Sheet 2 and in F2 type in "Yes" I want it to copy the new value to sheet 1 cell "B3"

Any help would be appreciated.

Sheet1​

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		UK1				France				UK2
2		England	Wales	Scotland	Ireland	Paris	Brittany	Burgundy	Normandy	England	Wales	Scotland	Ireland
3	Name 1	143	88	238	257	131	330	208	8	346	105	371	359
4	Name 2	147	310	53	342	152	182	284	82	93	81	162	17
5	Name 3	137	343	332	381	254	157	318	348	103	281	292	194
6	Name 4	32	28	354	79	324	81	12	224	16	65	189	259

<tbody>
</tbody>

Sheet 2 ​

	A	B	C	D	E	F
1				Current	Proposed Number	If Yes
2	Name 1	UK1	England	143	150	Yes
3	Name 2	UK2	Wales	81	150
4	Name 3	UK1	Scotland	332	200
5	Name 4	France	Paris	324	300

<tbody>
</tbody>