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

[kelkelkel08]

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!!!!!!!

[Lemice]

Hello and welcome to the forum,

This formula might be what you are looking for
=MID($B1,SEARCH("Mala-3",$B1)+5,7)

[kelkelkel08]

Hi Lemice!

Thanks for the welcome and the solution!! It works!

[Lemice]

Glad that I could help.

If you have found a fitting solution to your problem, please mark the Thread as [SOLVED] using the Thread Tools right above post #1. It keeps things neat and tidy.

And don't hesitate if you have any question.

Have a great day.