Formula to search a range for a string and then extract certain dta from string

Hi,

In the attached file, the data sheet contains a list of items in column A.
The output tab reflects the data I want to search for then extract from the Data tab, so I am looking for formulas to get the output shown in Columns A and B of the output tab.

The problem is that some of the data items are very similar in name, so using a wildcard to search makes things tricky.

In summary, I would like a formula that searches the range of column A in the data tab for the search criteria in Column E of the output tab, then output the findings to Column A of the output tab.
Then based on what populates in Column A of the output tab, I want to pull the corresponding percentages.

Here is one possible solution with two caveats:
1) All percentages MUST contain a decimal point
2) Text without any percentage will result in blank output, so the output must be filtered by non-empty cells.

The formula to find the text portion would be

Formula:

Please Login or Register  to view this content.

And the formula for the percentage value would be

Formula:

Please Login or Register  to view this content.

Thank you danielexcelvba and jtakw for your great responses. Both suggestions work perfectly.

You're welcome, glad it works for you, thanks for the feedback.