Lookup Data Table Add Data Row

working now? @Apple1

LookupDT2
getting error

d is D of your column name in excel change that in look up data table

what’s the status now? @Apple1

Files excel.7z (171.1 KB)
I attached my two excel files.
Can you please create working process and send .xaml file?
The result should look like:
Vlookup_result

I wrote all the steps @Apple1 what is the error coming?

LookupDT2

@Apple1 as mentioned above i told you the change the column name and make the d in capital like this way D
Delivery_code_file_1 and Delivery_code_file_2 for both lookup data table

working now or still any error?

it is in capital and still error

same error?

same error

the problem is with your excel file the one’s you have attached above

  1. they are macro enabled
  2. language is not english
  3. the column doesn’t even exists in the file the one you mentioned above
  1. Does not Lookup Data Table activity work with macro enabled file? What to do it this case?
  2. Language of office, column name and headers in English. Where is the problem?
  3. I create new column in Build Data Table activity in the process.

@Parth_Doshi
May be you can create new video instrucation for working with Macro Enabled Excel files for cases as I have?