I hope somebody can help me.

I have a list in column C of 13000 names with a reference number against
each of them in column D. The reference numbers are between 1 and 760 and
each of the 13,000 names in column C has one of the 760 numbers against it in
column D. In column F, I have the list of 760 numbers with text for each of
these numbers in column G.

I need to correctly insert the text for all these 760 names against my main
list of 13,000 names. To try to explain it I want to:

If number in any cell in column D equals the same number in any cell column
F, then paste the text in column G for that number to column E, to correspond
with the same number in column D.

I hope this is clear!

Daria