Cell contains one of many things

Hello from Australia down under, hi all, not sure if what I want is possible but it would sure be handy if it is. Here goes,

I have this formula and it does most of what I need,

=SUMPRODUCT(--ISNUMBER(SEARCH({"250","500","750"},M3)))>0

It finds the things I want but only returns a true or false, is it possible for it to rerun in text what it has found. In my case M3 contains the number 13250 which are “machine hours” and this sum has returned true for the “250” I would like it to return “250” rather than true.

Thanks for taking the time to read my post

Chris

Try:

=LOOKUP(751,SEARCH({"250","500","750"},M3),{"250","500","750"})

Phuocam you're a legend, it works, thank you, ill have a play and see if I can build on it now.

Cheers Chris