need formula for sub string in main string

[yallamanda.b]

Hi Team please find the attachment.
could you please share formula for sub string in main string

thanks

 

[rahulshewale1]

hii,


Please find the attached solution...

formula in B2=INDEX(list!$A$2:$A$5,MATCH(TRUE,ISNUMBER(SEARCH({"Washing Machine","Fridge","Sofa Set","Dinning Table"},required!A2)),0))


Thanks
Rahul shewale

 

[yallamanda.b]

Thank you so much..This i exactly want.

 

[Khalid NGO]

Hi,

One more:

=LOOKUP(2,1/(SEARCH(list!$A$1:$A$5,A2)),list!$A$1:$A$5)

Regards,