Formula parenthesis error

[farida__]

Hi everyone,

I created the following formula

=VLOOKUP(A2;A$2:M$2000;5;FALSE;IF(E2="On-going";"Ongoing";F2="Ideation";"Ideation"))

The aim is to:
- copy the data in column E to column D
- if the data in E says "on-going", I want it to say "ongoing" in column D
- if it says "Ideation" in column F, I also want it to say "Ideation" in column D

However, this formula isn't correct and Excel says it's a parenthesis problem. Can anyone please help?

Thank you in advance

 

[Fluff]

What the vlookup for?
From you description just use

=IF(E2="On-going";"Ongoing";IF(F2="Ideation";"Ideation";""))

 

[farida__]

I used the vlookup function to copy what was on column E onto column D. I didn't want to modify column E so that's why I copied it onto another column.

 

[Fluff]

But your not chnging the value of col E if the formula is in D