Matching data from Randomly Sorted Names.

Edit: I'm taking this to the General Forums because I don't know if it requires a formula or not. Maybe we can solve this without a formula, but if you can fix it with a formula, please do so.

I have three columns. Lets call them A, B and C.

Column A has a list of 30 students names in random order.
Column B has the same list of 30 students names in alphabetical order.
Column C has data about each student in Column B, next to it.

I need Column B,C to be in the order of Column A.

Sorting data question.JPG

Highlight entire range, go to Data/Sort & Filter, click the ZA/AZ button, follow instructions

Welcome to the forum.

Select the range A1:C5 | Insert | Table.

Sorry - ignore - I misread the requirement.

oops sorry. Then use INDEX/Match in helper columns

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

No need to open a new thread for this, you can continue here

(A mod has closed your other/duplicate thread )

Moved to the General section at OP's request.

I've uploaded an example of the requirements.

Name+Code stay together. I want these names(codes kept next to them) sorted into the same order as the names in Column A.

Please view uploaded file.

Edit: Not sure if this needs a formula or not, but I asked it be moved to General to include formulas as well as other solutions.

In B2 copied down:

=VLOOKUP(A2&"*",$D$2:$E$6,2,0)

Well, the thing is, some of the names in the lookup list don’t match those in column A - they have a hidden trailing space. So, I added the wild card after the lookup value to make it find the matches. Otherwise, it’s a big standard VLOOKUP, so Google that to read up about it and its syntax.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.