Write Cell Excel Formula Issue VLOOKUP

Help Studio
, , ,
1

Hi,

I get an error when I want to enter the following command in my cell in excel. Does anyone know your problem ?
All my transactions are on the same sheet

Source: Write Cell

Message: The write operation failed, because one of the following reasons:
► The data you want to write “=VLOOKUP(A:A;K:M;3;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.

image

2

As the error message suggests, use commas to separate the parameters instead of semicolon.

"=VLOOKUP(A:A,K:M,3,0)"

3

I using vlookup with semicolon in excel (Office 365). It works like that.

4

@ilkeruznglu

If you see the third point in the error may be we need to try with comma…can you please try the same

cheers

5

Unfortunately not works

6

Your formula is wrong. it would result in a spill (in which case your destination shouldn’t be a range but a single cell location)

it should be this:
“=VLOOKUP(A2;K:M;3;0)”

1 Like
7

Hi, I try this and updated manage packages (excel.activities). Its works. Thank you soo much

8

Hi, Thanks for your help. Worked above comment.

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.