IF - value if true - text + formula

Hello!

I have a formula:
=IF(COUNTIF($C$3:$C$5000,$C659)>1,MATCH(C659,$C$1:$C$5000,0),"")

I want to have a text precending MATCH result: "Duplicate - "

So what I want: if countif returns >1, I get "Duplicate - " text followed by result of MATCH function.

I tried =IF(COUNTIF($C$3:$C$5000,$C659)>1,"Duplicate - " MATCH(C659,$C$1:$C$5000,0),"")
and =IF(COUNTIF($C$3:$C$5000,$C659)>1,("Duplicate - " MATCH(C659,$C$1:$C$5000,0)),"") with no luck...

Try this:

=IF(COUNTIF($C$3:$C$5000,$C659)>1,"Duplicate - "&MATCH(C659,$C$1:$C$5000,0),"")

Hope this helps.

Pete

Originally Posted by Pete_UK

Try this:

=IF(COUNTIF($C$3:$C$5000,$C659)>1,"Duplicate - "&MATCH(C659,$C$1:$C$5000,0),"")

Hope this helps.

Pete

Yeah, great. Thanks... Such a simple solution..