Hi all, Im a newcomer to the site, have been in the background for a while and have got some great help and tips from this forum, but now I have a question that I can't find an answer to.
I have 2 worksheets, 1 & 2.
Number 1 has a list of clients i.e tom, john, paul and each client has several different values at different dates i.e
Tom - 15
Tom - 20
John - 30
John - 35 etc.
On worksheet 2 I have the full list of clients in the first column and on the second column I need to have the total for each client from worksheet number 1.
Can anyone advice a formula I could use in worksheet 2 that will lookup the client name in cell A1 and return the total for that client from worksheet 1?
Many thanks.