Simple Search for Value Function

[amonty78]

Hi all,

I am needing some help on a search formula. I have attached an example if it helps.

I have names in column D, and numerical values in column E.
Using row 11 as an example, I need a formula G11 that will look at the text (in this case the name) in D11, then search the remainder of Column D for the same name, and then return the value in the adjacent cell (in row E). In the example used, the value returned in cell G11 is 7.

Any help on this one would be much appreciated :-)

Thanks.