Putting One Column of Words in the Same Order as Another

**One-Eyed Enos** · 05-02-2012, 10:36 PM

This is a little tricky to describe, but I'm sure it's a common beginner's problem. Suppose I've got a column of a hundred words or categories, each with its associated value in the next column. Somewhere else I've got the same hundred words in a column, but in a completely different order, and with different associated values. How do I tell Excel to put the second hundred words into the same order as the first hundred words?

Thanks in advance.

**Fotis1991** · 05-03-2012, 02:22 AM

Hi

One way to do this, is this..

Copy the words from the first column of words.

Paste in a another column that you like.

Then use INDEX & MATCH functions to find your numbers..

Take a look to the example. I use different Sheets in data, to be more clear.