Write Cell Excel Formula Issue VLOOKUP (Different Sheets, Same Excel)

Hi,

I get an error when I want to enter the following command in my cell in excel. Does anyone know your problem ?
My transactions are on the sheet1 and sheet2

Source: Write Cell

Write Cell: The write operation failed, because one of the following reasons:
► The data you want to write “=VLOOKUP(B:B;Sheet2!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.

@ilkeruznglu

Please use comma instead of semi colon in your formula

Cheers

Thank you soo much

1 Like

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