VBA Code to include VLOOKUP formulas

Hi all,

Please refer to the attachment before attempting to solve my problem. Thanks again in advance for looking and trying to help.

If you navigate your way to sheet 2 in the spreadhseet, you will see that Column has been pre-populated with numbers. I need if it's possible, a macro to insert two VLOOKUP formulas starting in Cell C2 and D2 to loop to the last number in Colum B. The 1st number will always start in Cell B2, but the list of numbers presented will always be different.

I have populated both cells C2 and D2 with the VLOOKUP formula I need included in the macro.There will be data in Sheet 3 once I've completed the spreadsheet.

Thanks for looking.