Value corresponding to the name

[shimaa01234]

HI,
I own this table
1 - There's column "A" Names
2 - There's column "B" Values
The cell "C1" drop-down list of names
I want when the name selection is brought corresponding value even if repeated Name?
I want the solution by formulas

M1	2	M1
M2	3	2
M1	5
M3	6
M4	8
M5	0
M1	4

<tbody>
</tbody>

 

[shimaa01234]

very good solution

 

[shimaa01234]

I want if the cell = (m 1) corresponding to the number (2), the cell (E2) = A
I want if chosen from the drop-down menu (1 m) corresponding to the number (5), changing the cell (E2) to (5), and so the number (4)
I'm sorry
Mister "Aladdin"
The effort with me
This link file you want
https://app.box.com/s/zmqf8qpt5daj1rxotp1q

 

[shimaa01234]

Mister "Aladdin"
This solution, but I want a formula by "drop-down list" normal
And not by the "Combo Box"
Is it possible that
https://app.box.com/s/cmjwz0elrq3726o3amdc

 

[shimaa01234]

up

 

[shimaa01234]

I need help please!!!!!!!!!!!!

 

[shimaa01234]

Is there a solution to this request? Or not?
I hope that there will be an answer?
Thank you anyway