VBA code to copy and paste data from one sheet to another, variable locations

In summary, I am trying to achieve the following:
-I have a workbook containing two sheets (Sheet1 & Sheet2) Sheet1 will contain raw data a number label in columnA and the data value in columnB, sheet2 will contain formula at various locations
-I would like to be able to enter two variables in sheet2, in cells A1, and B1. When the code is ran I would like excel to search sheet1 columnA for the value entered in sheet2 A1, copy the adjacent data value, then search sheet2 columnC for the value in sheet2 B1 and paste to the corresponding adjacent cell in columnD.
I have the code below which will complete the first two parts of the procedure.

Please Login or Register  to view this content.

This searches columnA sheet1 for the value in sheet2 A1 and copies to a set location (D3).

What I need is for the paste location to be either D3 or D6, depending on if the value entered in B1= the value in C3 or C6.

Does anyone know how to change the paste location , based on the concept described above?

Note. I have simplified this as much as possible for the purposes of getting code to work, in practice I will need to adapt it to copy several batches of rows at a time to several possible locations.

Apologies I cannot post the spreadsheet; the version I am using has a proprietary VBA installed (that is nothing to do with this particular calculation) which I am not allowed to post

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks