Vlookip to VBA Script

Hello Guys,

Was wondering how I would put the following into a vba script:

=VLOOKUP("*"&A2&"*",Sheet2!B:B,1,0)


I would usually put this formula into cell B2 of Sheet One and drag it down to the whole column - but I was wondering how i would put this in a vba script and have the vba script put my results in Column B of Sheet 1. Thank you in advance for your assistance.


Cheers,

Please Login or Register  to view this content.

Hello Vik,

When i use your formula i get the following error: "Type Mismatch".

Cheers,

Maybe:

Please Login or Register  to view this content.