Combine 2 IF formula return 2 different value

For xl2010 you will need to test each cell individually like

Formula:

=MID(IF((ISNUMBER(SEARCH($B$2,A2))),","&$B$2,"")&IF((ISNUMBER(SEARCH($B$3,A2))),","&$B$3,"")&IF((ISNUMBER(SEARCH($B$4,A2))),","&$B$4,""),2,1000)