Hello everyone,
I got a code that opens another workbook (and is working as intended), but then I would like to do a vlookup into the start workbook from the workbook that was just opened. In the file that is opened up there is just two columns with data. Row 1 is a header but this is my table_array in a vlookup where the col_index_num is 2 (the second column). My lookup_value is on the other hand from my start workbook where the lookup_value is in column 4 (D). The destination of the result (value) of the vlookupformula is in my start document in column 16 (P). My code is below but I do something wrong with my vlookup formula I think.
Please Login or Register to view this content.
Bookmarks