finding text in array [SOLVED]

[madocar]

Hello guys,


Could you help me please? I attached the file


http://www4.zippyshare.com/v/53510441/file.html


In column A, column B, column C are data. In column called Result I wanna get one of the three words (BISTRO,CAS,CESTOVANIE)

For instance in cell D2, if in the range A2:C2 is the word Bistro, the result will be BISTRO, if in the range A2:C2 is the word cas, the result will be CAS, if in the range A2:C2 is the word cestovanie, the result will be CESTOVANIE.


But there is some kind of mistake which I dont know to solve


Many thanks

 

[NARAYANK991]

Hi ,


Put this formula in D2 , and copy down :


=(IF(OR(ISNUMBER(SEARCH("Bistro",A2:C2))),"BISTRO",IF(OR(ISNUMBER(SEARCH("cas",A2:C2))),"CAS",IF(OR(ISNUMBER(SEARCH("cestovanie",A2:C2))),"CESTOVANIE",""))))


Enter this as an array formula , using CTRL SHIFT ENTER.


Narayan

 

[madocar]

Thank you so much NARAYANK991