Excel IF(ISERROR Formula Error

[SMK5197]

I am having issues with a complicated formula that has previously worked. In the past this formula insert text in 70-100 cells. Now I am only yielding text in about 15 cells.

The goal of the formula is to copy the text from cell CO3 into cell CP2, if cell E3 = "system" and the text in CO3 is also found in column A of "Outsmart-Outsellv2".

Below is the formula I'm using. Any tips are greatly appreciated!!

=IF(ISERROR(VLOOKUP(CO3,'[Outsmart-Outsellv2.xlsx]New System Deals (2 REFRESH)'!$A:$A,1,0)),"",IF(E3="System",VLOOKUP(CO3,'[Outsmart-Outsellv2.xlsx]New System Deals (2 REFRESH)'!$A:$A,1,0),""))

 

[Jonmo1]

Welcome to the board.

The goal of the formula is to copy the text from cell CO3 into cell CP2, if cell E3 = "system" and the text in CO3 is also found in column A of "Outsmart-Outsellv2".

Try

=IF(AND(E3="System",COUNTIF('[Outsmart-Outsellv2.xlsx]New System Deals (2 REFRESH)'!$A:$A,CO3)),CO3,"")