I am trying to look up text and return a value.

Brief explanation:
I am trying to look up text and return a value.

The key words I am looking up are contained in worksheet 1.

Worksheet 2 contains a table with 3 columns. Column 1 is a work order number. Column 2 is a description of the work order with keywords embedded in there somewhere. Column 3 contains a status of the work order (closed, open, researching)


I need to find the work order number and status of the work order for each keyword. Attached is a sample workbook. Help!

My lookup dilemma.xlsx