Link between cells (chose other by choosing one)???

[Vedran1]

Dear all,
I'm new on this forum and would like to regards you all.
I'm having a problem finding correct formula for the task I have.
Let me try to explain what I want.
In one column I have names of something, in the next I have values for that name.
What formula can I use to get values when I chose names?
Let say that I have like this:
Anna 50
Mary 62
Tim 81

Anna+Mary+Tim=193
(basically I need some connection between first and second column, so that when I chose name actually I'm choosing values)
Possible?

Sorry for my lousy English and lousy excel...

[zbor]

You can try with VLOOKUP function:

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Then you get something like this:

=VLOOKUP(C1;$A$1:$B$13;2;FALSE)+VLOOKUP(D1;$A$1:$B$13;2;FALSE)+etc...

Where A1 to B13 are defined your values as in your example
and C1, D1... you write name you want to sum

[zbor]

Or better look here few solutions... Maybe last one (green) would be most interesting for you:

[Vedran1]

Or better look here few solutions... Maybe last one (green) would be most interesting for you:

You're THE MAN!!!
excelent, thank you very much.
SUMPRODUCT works great.
Please see my next problem (subject) and try to help me once again.

[teylyn]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[zbor]

Don't forget to make thread [solved]

Go to first post -> Edit -> Go advanced -> choose solved from drop down menu