Hi

I am making a excel sheet where cell I27 are counting spesific products from C63:C65 and this is working perfectly. But I have problems getting cell L27 a text string of spesific word from cell C63:C65.

Ex: L27 are only looking for "apple" and "banana". C63=Apple C64= House. Then L27 should contain "Apple" only. I have this formula but it only adds everything: =IF(ISTEXT(C63),CONCATENATE(C63," ",C64," ",C65),"")