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
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