Scripting Dictionary (working as vlookup) and add calculated columns

Hi,
im working on the project :
I got the code for making script dictionary working as vlookup from another spredsheet

Please Login or Register  to view this content.

This part of code making just straight vlookup based on a key from range A:A in sheet2 (and look it up in sheet1), and then put them in sheet2.
What i need to do is after this copying the dictionary would look in the source for reference and for example add values from Column O and Column P from sheet1 and put them next to vlookuped values in sheet2.

Best Regards,
Mumsy

"Next"?

Please Login or Register  to view this content.

Thx for answer, unfortunately i got object doesn't support this property or method error on line

Please Login or Register  to view this content.

I'm posting example workbook to get lil more visual about it:

If somethings unclear there pls ask
BR,

Sorry that was a typo, should be "exists"

You will need to adjust the array as per your real data layouts.

Please Login or Register  to view this content.

You could use Val function to convert it as Double.
i.e

Please Login or Register  to view this content.

And so is the rest...