Multi-column IF statements

I've written a bit of pseudocode to try and summarise what I'm trying to do, and am currently struggling with the returning bit of the problem:

enter image description here

If value of cell (A2) is found in cells (D2:D42):

X = row number of cell in which value of (A2) was found

Print in cell (E2) the value of cell (E X)

I can do the first line, the actual IF statement, but it's then returning the value of the cell in column E in the row in which the value of A2 was found. Convoluted, I know. Anyway, how can I do this?