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.

Not sure why you think you need VLOOKUP - put this formula in A1 of Sheet2:

=IF(Sheet1!$B2="Word",Sheet1!C2,"")

then copy across to C1.

Hope this helps.

Pete

Thank you for answer and it works very well but i was gave very poor explanation what i wont actually,i will try again.

Basically my goal is to make some files for control my stock condition,you know orders/receive files in lists separately by goods which we have in our warehouses,i spread my Sample files and attached again.

Thank you for understanding i give my best.