Simple Search for Value Function

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.

Try this.

Formula:

=INDEX(E12:$E$33,MATCH(D11,D12:$D$33,0))

if it doesn't exist again it will give #N/A you can use this formula if you prefer to return nothing

Formula:

=IFERROR(INDEX(E12:$E$33,MATCH(D11,D12:$D$33,0)),"")

Thanks very much guys, both of those options work perfectly !!
Thanks again.