Vlookup for dynamic datarange using iNVOKE CODE activity

Help
1

Hi

is there any invoke code activity where we can customize the code according to need for vlookup task in excel

2

You can use invoke vba to invoke macro code or the macro activity to invoke a macro in a workbook that has macros