Hi All

I’m trying to type the folowing Formula in excel “=IF(A2<>"Not assigned";A2;IFERROR(VLOOKUP(B2;‘A MEMO’!$A$6:$B$12;2;FALSE);"Other Products"))”. I keep getting te error “End of expression expected”. i tried writing the formula in a other workbook and using read Fromula but it doenst take the “=” along. i also tried wrting it like this “=IF(A2<>”““Not assigned””“;A2;IFERROR(VLOOKUP(B2;‘A MEMO’!$A$6:$B$12;2;FALSE);”““Other Products””“))” this takes away the error but then i get a error in Excel

Does anyone have a solution to this problem?

Please use two double quotes instead of one in the write cell activity. It will solve the problem.

Could you show me an example? Because i thinik i have tried that but it still didn’t work for mee

and double qoutes in front of the fromula or inside the formula

Inside the formula.

`“=IF(A2<>""Not assigned"";A2;IFERROR(VLOOKUP(B2;""A MEMO""!$A$6:$B$12;2;FALSE);""Other Products""))”`

this formula give’s me no errors “=IF(A2<>””““Not assigned””““;A2;IFERROR(VLOOKUP(B2;‘A MEMO’!$A$6:$B$12;2;FALSE);””““Other Products””““))” but it does give me a error in excel

Did u tried the below expression -

`“=IF(A2<>""Not assigned"";A2;IFERROR(VLOOKUP(B2;""A MEMO""!$A$6:$B$12;2;FALSE);""Other Products""))”`

And also try replacing semi colons( with comma (,) in the formula.

The error goes away but is stil give me the same error in excel

this is the error, do you know how to fix this

i also tried replacing ; with a , but it still doesnt work.

The below is the right one -

`“=IF(A2<>""Not assigned"";A2;IFERROR(VLOOKUP(B2;'A MEMO'!$A$6:$B$12;2;FALSE);""Other Products""))”`

thank you this is the right one, However it come in text i need to drag it down to the end of the table and it should be in general. Do you have Know how i can make this happen

Just use copy paste range to copy to other cells.

The formula will work and updates automatically.

But how do i get it to general, because as you can see in the image in my earlier post it shows the Formula but not the result

When i use Copy paste range i only copies the formula to the cel bellow and it doesn’t change with the cell it should become A3 and B3

Hi @athevan96

If the formula is working correct, try using the excel “AutoFillRange” activity. It will apply your formula to your desired range.!!

Hope it works for your test case.!!

Hi @athevan96

Please give file and what exactly you want…will share you the solution. Also you have not ended IFERROR activity thats why this is giveng error