Lookup ****** value and return value in cell

Enquiry.

Formula =IF(ISNUMBER(SEARCH("Mala-3*******",$B1)),RIGHT($B1,7)," ")

Capture.JPG

I am trying to look up Mala-3******** with 3******** representing any value. But the value if true is 7 characters which returns the value of "ted and".

is there any formula where i can actually return the value looked up instead of "ted and"

Help appreciated. Many Thanks!!!!!!!