How to put variable into a write cell activity?

[yangyq10 (IvanY)]

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 best way to make it happen?

Thank you for your kind advise in advance

Regards

[lrtetala (Lakshman Reddy)]

Hi @yangyq10

Please check this

How to use vlookup for two different excel file?

@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:(Input) [image] Excel2:(Input) [image] Excel1:(Output) [image] Cheers!!

Regards,

[Yoichi]

Hi,

@yangyq10

But turns out error while I debug

Can you share what error you have?
Also check if content of strFilename_1 is same withwhat you expect.

Regards,

[Baskar_Gurumoorthy]

Hi @yangyq10

can you refer the below thread.

How to pass variable in write cell range

Hello @sathish_Kumar6 There is a property “Text” for the activity which you can pass the value [image] Thanks, Mousa

try to add to string in strFilename.Tostring , also you can use & symbol instead of “+”.

Hope it helps!!!

[yangyq10 (IvanY)]

@lrtetala Thank you, I know why I got error. Sth wrong with my variable

[yangyq10 (IvanY)]

@Yoichi You are right. Sth wrong with my variable. Thank you for the headsup

[yangyq10 (IvanY)]

Let me keep trying. Thank you