Find and replace for Vlookup activity problem

[Mehran_Mohajeri]

Hi guys,
Please let me solution about how can i fix the problem as attached.

Thanks and regards
Mehran

[bhavesh.choubey]

Possible Causes and Solutions:

1. Excel is Busy / Cell Is Being Edited

• Cause: Excel might be open and a cell is being actively edited or selected.
• Solution: Close all Excel windows or make sure no cell is in edit mode. Use the “Kill Process” activity to close Excel before writing.

2. Incorrect Format in Data

• Cause: You’re trying to write an invalid or unsupported value (e.g., DBNull, Nothing, or malformed formulas).
• Solution: Make sure the data you are writing is not empty, or convert it using ToString() if needed. Also, validate data types before writing.

3. Wrong Formula Format

• Cause: If you’re writing a formula (like =VLOOKUP(...)), commas must be used instead of semicolons depending on your system’s regional settings.
• Solution: Use this format for formulas in UiPath:
  =VLOOKUP(A2,Sheet2!A:B,2,FALSE)
  (Use commas, not semicolons).

4. Excel Dialog Box Is Open

• Cause: A popup (like a Save prompt, password prompt, or alert) is open in Excel during the write operation.
• Solution: Ensure no dialog box is open in Excel. Automate Excel silently or use the “Excel Application Scope” with Visible unchecked.

If you found this solution is correct than please mark it as SOLUTION

Happy Automation

[prashant1603765 (Prashant Kumar)]

Hi @Mehran_Mohajeri

Check below lik,

Excel Application Scope: The write operation failed, because one of the following reasons: ► The data you want to write "=FILTER(SEQUENCE(ROWS(A:A)),(D:D=$K$2)*(F:F=$J$2),"")" has a wrong format; ► Excel is busy;

When I write this formula “=FILTER(SEQUENCE(ROWS(A:A)),(D:D=$K$2)*(F:F=$J$2),”“)” in excel using write cell activity I’m getting below error. Can someone please help me with the syntax? What is the right format here? Excel Application Scope: The write operation failed, because one of the following reasons: ► The data you want to write “=FILTER(SEQUENCE(ROWS(A:A)),(D:D=$K$2)*(F:F=$J$2),”“)” has a wrong format; ► Excel is busy; ► If your data is a formula, make sure you use comma as parameters…

If you found helpful, feel free to tick as a solution.
Happy Automation