Getting error while writing VLOOKUP formula in Write cell activity

Help Studio
, ,
1

Hi forum,

I am getting error in write cell activity when I write this VLOOKUP formula

“=IFERROR(VLOOKUP(I2,‘E:\UiPath\DATA\Master Sheet for Day Book & TB[Master Sheet of GL Acc, Customer, Vendor.xlsx]Sheet1’!$A:$B,2,0),”“)”

2

Hi @Mayur_N

Can you show the screenshot of the error, meanwhile try below

"=IFERROR(VLOOKUP(I2,'E:\UiPath\DATA\Master Sheet for Day Book & TB[Master Sheet of GL Acc, Customer, Vendor.xlsx]Sheet1'!$A:$B,2,0),"""")"

Regards,

3

Hi @Mayur_N

"=IFERROR(VLOOKUP(I2,'E:\\UiPath\\DATA\\Master Sheet for Day Book & TB[Master Sheet of GL Acc, Customer, Vendor.xlsx]Sheet1'!$A:$B,2,0),"""")"
4

Write Cell: The write operation failed, because one of the following reasons:
► The data you want to write “=IFERROR(VLOOKUP(I2,‘E:\UiPath\DATA\Master Sheet for Day Book & TB[Master Sheet of GL Acc, Customer, Vendor.xlsx]Sheet1’!$A:$B,2,0),”)" has a wrong format;
► Excel is busy or you are currently editing a cell;
► If your data is a formula, make sure you use comma as parameters separator;
► During the write operation make sure no dialog windows are opened.