Finding specific data within cells

Hi,

I need some help with a function. I'm trying to search through multiple cells in a column to find specific values listed in a separate column. If one of the values is found, I would like it to return just that value into a separate cell in the same row as the cell in which it was found.

In the attached spreadsheet, I need a formula to look for all the values in column D in the cells of column A, and if found return the value into the cell in column E. Basically I'm trying to locate and extract specific information from column A.

I've been playing around with combinations of the search and lookup functions, but to no avail. Is this possible?

Not sure I understood fully, but this formula:

=LOOKUP(9.999999E+307,SEARCH($D$1:$D$4,A1),$D$1:$D$4)

will extract whichever value from D1:D4 is contained in A1 and enter that value in E1...

Copying down with check against A2, A3, and so on....