IF the above cell = next then leave empty cell in another Column.

[Old R2D2]

Hello friends ,

I need a little help with this formula :

I have already set the formula that transfers values from one sheet(source) to another(destination) and works fine.

=IF(ISNUMBER(SEARCH("TPL";APO!B3));"TPL";IF(ISNUMBER(SEARCH("PIS";APO!B3));"PIS"; ))

Now in the above formula, I want to leave one cell empty in another column (A) , IF the above cell is equal to the next in Column (C).

When (C3=C2);"" ; ) ; Leave in Column (A) cell A3 empty.

=IF((C3=C2);""; ) ;IF(ISNUMBER(SEARCH("TPL";APO!B2));"TPL";IF(ISNUMBER(SEARCH("PIS";APO!B2));"PIS"; ))

When I try to run the above formula a "#Value" error problem appearing ..

Any thoughts ?

I really appreciate any help you can provide.

I left some spaces in characters like the "()" and ";" because it turn to emoticons !

[CRIMEDOG]

it is the ) =IF(C3=C2,"",IF(ISNUMBER(SEARCH("TPL",APO!B2)),"TPL",IF(ISNUMBER(SEARCH("PIS",APO!B2)),"PIS",)))

[Old R2D2]

Thank you CRIMEDOG for your answer !

Actually I have corrected the above because characters like "()" and ";" turn to emoticons ! So now it is corrected.

If I run separately the first " =IF(ISNUMBER(SEARCH("TPL";APO!B2));"TPL";IF(ISNUMBER(SEARCH("PIS";APO!B2));"PIS"; )) " and second " =IF((C3=C2);""; ) ; "

then in both cases it is running fine !

but when I try to run it as one formula " =IF((C3=C2);""; ) ;IF(ISNUMBER(SEARCH("TPL";APO!B2));"TPL";IF(ISNUMBER(SEARCH("PIS";APO!B2));"PIS"; )) "

the "#value" error problem appears !