What's wrong with this IF statement?

[Frank Bacchus]

Hi All:

Happy cinco de mays. Can you please let me know what is wrong with this statement:

=IFERROR(VLOOKUP(A2, NDC_Server_Launch_Export_Workin!$A$2:$X$81,11,0), IF (Q2=”P", “Pending”,Finished")

thanks in advance

frank

 

[NARAYANK991]

Hi ,

See if this does what you want it to do :

=IFERROR(VLOOKUP(A2, NDC_Server_Launch_Export_Workin!$A$2:$X$81,11,0), IF(Q2="P", "Pending","Finished"))

Narayan