Combine two formulas and add a condition if True

[DougStroud]

I have two formulas that I have worked out to deliver the results independently. I would like to join them together into one formula and add an If condition that if the two match then add a "+" to the end of the string.

#1 finds the base value :
=IF(ISERR(FIND("/",I2)),I2,LEFT(I2,FIND("/",I2,FIND("/",I2)-1)-1))

#2 verifies the value is a valid color:
=INDEX(M1:M41,MATCH(J2,M1:M41,0),1)

I would like to join the two formulas together and if they match then add a space, " " and a "+" to the end of the string. If there is no match then return the base value.

Hopes this is clear.

Thanks,

Doug

 

[DougStroud]

Hp,
Looks like a winner. One detail- On a value that does not have a "/" it still returns the value w/ a "+".
Black by itself should only return Black, not Black +
and it does....

 

[Scott Huish]

=LEFT(I2,FIND("/",I2&"/")-1) &IF(ISNUMBER(FIND("/",I2))*COUNTIF($M$1:$M$41,LEFT(I2,FIND("/",I2&"/")-1))," +","")

 

[DougStroud]

Hp,
I will test in a little bit. Having to solve some hardware issues at the moment.

best,

doug