# How can I match Names to Numbers?

1. ## How can I match Names to Numbers?

If I were to copy/paste a list of names and a list of scores and put the names from A1-A7 and numbers in B1-B7:

Alan 98
Bob 93
Chris 88
Dave 75
Eric 73
Fred 71
Greg 66

And then in C1-C7 list names and D1-D7 list new numbers:

Eric 100
Alan 99
Dave 95
Bob 88
Greg 77
Chris 74
Fred 63

Is there a way to 'match' the names and list them in order? so I can then just total their grades (adding B1 and D1 in this example). I realize in my example I can just list in alphabetical order, but is there a way to organize the names using another function?

2. ## Re: How can I match Names to Numbers?

If the order that the names occur in column C is sufficient then you could put the following formula in E1 and copy down:
``Please Login or Register  to view this content.``
Let me know if you have any questions.

3. ## Re: How can I match Names to Numbers?

That is great JeteMc, thank you. So in this formula, you arent actually moving anything from C to match the order of A.....am I correct that you are simply matching C1 to A1 in a way to organize it so it's added to D? Do I have this correct?

this formula is locking in "C" do I have that right? so the order is now based on C, not A, right?

thank you again

4. ## Re: How can I match Names to Numbers?

Yes, the total scores are reported in the order that the names appear in column C. You are welcome and thank you for the feedback. If your question has been answered satisfactorily please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.

5. ## Re: How can I match Names to Numbers?

Deleted by JeteMc

6. ## Re: How can I match Names to Numbers?

Originally Posted by JeteMc
Yes, the total scores are reported in the order that the names appear in column C. You are welcome and thank you for the feedback. If your question has been answered satisfactorily please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.

you were very helpful and did answer my question. but if I may, before I mark Solved, ask one followup please. what would the code be for a 3rd group of names and numbers? Names in A, C, E. Numbers in B, D, F.

Would you mind please explaining how that would work? And again, thank you for everything.

7. ## Re: How can I match Names to Numbers?

Here are a couple of ways to do that, and someone may very well have a better one. One way would be to simply add another layer of index/match like so:
``Please Login or Register  to view this content.``
A second way is to use the Sumproduct function like so:
``Please Login or Register  to view this content.``
You could paste either in G1 and down.
Let me know if you have any questions.

8. ## Re: How can I match Names to Numbers?

very wonderful. thank you

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1