Integrate VLOOKUP in VBA

[Bart1980]

Hello everyone,

I have a workbook with two worksheets namely "1" and "Sheet1". I would like to write a macro which integrates the VLOOKUP function.

My working function is as follows: =IF(H2="";"";VLOOKUP(H2;Sheet1!A:C;3;False) but I am kind of stuck with how to get it to work in VBA.

In Worksheet "1" I want to write the results in column J, starting from J2 of course. If the value of H2 from this Worksheet matches a value in Worksheet "Sheet1" column A, then write the corresponding value of Sheet1 column C in J2. Do this for all the values in Worksheet "1" column H.

Hope one of you can help me out.
Thanks in advance,

Bart

 

[Fluff]

Do you want to put the formula into the cell, or the value it returns?
Also how many rows do you have on both sheets?

 

[offthelip]

Have a look at this thread which gives a vba alternative to Vlookup
Vlookup VBA Alternative