I dont find the formula which can help me.

[noori]

Weeks---Names-----Amount earned
1-------Peter-------100
2-------Jone--------75
3-------William------150
4-------Jone--------25
5-------Peter-------50
1-------William------100
2-------Peter-------150
3-------Jone--------75
4-------Peter-------100
5-------Jone--------50
1-------William------125
2-------Jone--------100
3-------William------150
4-------Jone--------200
5-------Peter-------100

Hello,
I want when I chose the name in the cell name: it shows the compelete history of the whole picture/detial of that person(from the data table shown above.) like which weeks he worked / how much salary he got that week. For example: Cell week and salary. (If week 5 is write two times it add and show one amount).

Second thing is if I write in name(which is list of three nameseter, Jone, William-[data validation-list]) like if I write p then it show peter and if i press W shows william, if i press J then come up jone.

Name-----week-------Salary
Peter-------1--------100
------------2--------150
------------4--------100
------------5--------150
Please any suggestion how can I do. Will be grateful to you.

 

[Joe4]

You have posted this question four times now, including in forums such as the "Questions in Other Languages Forum". Please do not do this.
All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted:
http://www.mrexcel.com/forum/showthread.php?t=127080

I have deleted all but your original question, and locked this one.
Original post: http://www.mrexcel.com/forum/showthread.php?t=531549