matching entries in different columns

Hi, I have a worksheet (see attached for example) with two parallel sets of data, a list of words (A), with a number beside them(B), and another list of words (D), with another number beside them (E) -- eg.


will 0.76 ball 0.34
all 0.54 keen 0.23
keen 0.12 cool 0.99
done 1.3 will 0.12
aspect 2.4 cool 0.34
cool 1.2 keep 0.12


The word columns have some values in common, but are not identical, and are in a different order (sorting will not bring them in line because of their different contents). What I want to do is to have the word in column A lookup to see if there is the same word in column D, and if there is one, divide its relevant value by the value in E. E.g, will: 0.76 / 0.12 = 6.33. I would like to have these results then put into a new column that goes down the sheet inline with A.

Any thoughts?

cheers, Sam