VLOOKUP Question (VBA)

Hi all,
I'm scratching my head on the below codes.
It was working in one of my spreadsheet but when I try to apply it to the new one I am working on, it does not seem to work.
Any idea what I am doing wrong?

Please Login or Register  to view this content.

I wanted to see value on the target cells not formulas.
Any suggestions? Or perhaps better way of doing this?

Thanks in advance.

Try this...

Please Login or Register  to view this content.