Hello,

I am trying to write a code that will do the following:

- Search **column A** in **sheet1** for a match to **C1** in **sheet2**

- if there is a match in column A then copy the value in **column F** of the corresponding row

- Paste in** E14** of **sheet2**

Here is the code I have so far but I feel like I am way off.

Code

Any assistance would be greatly appreciated.

Many thanks