Vlookup the row if in cell some text.

Hello guys,

I hope that you are doing well and i also hope that you can assist in my problem.

I'm very familiar with Vlookup function,please tell me if possible using Vlookup according to specific text inside of cell.

Thank you for watching my question.