Dear Expert I have a request as below: I need to vlookup value from another file [YAMADA 0516-1.XLSX] into cell J2 However, the file name is a variable [strFilename], therefore I have to input this variable into the [write cell] activity. But turns out error while I debug May I know what is the…

Hi @yangyq10 Please check this [image] How to use vlookup for two different excel file? Studio @suraj_gaikwad You can pass the file name dynamically in a variable like below FileName="Excel2.xlsx" "=VLOOKUP(B2,[" + FileName + "]Sheet1!$B:$B,1,0)" [image] Excel1:(Inp…

How to put variable into a write cell activity?

Help Activities

lrtetala (Lakshman Reddy) May 16, 2024, 8:25am 2

Hi @yangyq10

Please check this

Regards,

Topic		Replies	Views
How do I write two or more variables into one excel cell StudioX studiox , question	8	801	July 14, 2023
Writing Variables to the Write Cell Activity Activities excel , activities , question	6	1319	February 9, 2021
How to use variables to build a Excel File Activities datatable , excel , activities , question	12	1487	July 7, 2023
How to write add a variable to write cell formula Activities excel , activities , question	5	761	June 29, 2022
Error using studio x during vlookup activity StudioX studiox , question	17	410	December 20, 2023

How to put variable into a write cell activity?

Related topics