# Help with sorting columns side by side

1. ## Help with sorting columns side by side

I'm making myself a bit crazy trying to figure this one out. I have 2 columns full of information that isn't completely the same in both columns. I've sorted each column into alphabetical order and now that's complete, I would like to sort side by side so that data from column A matches data from column B and where data doesn't match the cell is left blank. Is this possible?

Any help would be greatly appreciated.

Many thanks,
Marciarita

2. ## Re: Help with sorting columns side by side

Is the data in Column A exactly the same as Column B, even though there's some gaps?

3. ## Re: Help with sorting columns side by side

Hi - The columns are not completely the same. I am trying to sort a very long list of banks in which both columns have a list A-Z, however not all banks in Column A are in Column B. This is the main reason why I'm trying to do a side by side sort so I don't have to do a manual check. I'm ultimately trying to figure out where the info Column A and info from Column B are different.

Thanks.

4. ## Re: Help with sorting columns side by side

Here, try this:

I used VLOOKUP to pull the records. Then there is no sorting needed.

VLOOKUP(LOOKUP WHAT, WHERE, RETURN WHAT COLUMN, [0 FOR EXACT MATCHES])

and nested it inside IFERROR to return blanks for missing entries

Attachment 261077

5. ## Re: Help with sorting columns side by side

Wow! Thanks Daffodil11. This is great, however I'm still having a hard time figuring out how to use that particular function so a bit of work to do. For some reason I can't seem to figure it out.
Many, many thanks!

6. ## Re: Help with sorting columns side by side

No problem, glad I could help.

I elaborated a bit more on the use of the formula here.

Attachment 261362

7. ## Re: Help with sorting columns side by side

Thanks. The link doesn't seem to be working....

8. ## Re: Help with sorting columns side by side

Sorry about that. I had a network error while deleting a file yesterday and I lost over half of my uploaded attachments.

VLOOKUP for marcia.xlsx

##### Users Browsing this Thread

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