Solved

Excel Forula to line up matching cells

Posted on 2016-10-20
3
43 Views
Last Modified: 2016-11-21
Please see attached...

I have two Excel columns containing email addresses.
I need to run a function to make them line up, using column A as the master, search column B for the same address, then move it to the same row.

I cant just sort the two columns as there are addresses missing, so I want to be able to see the blanks.

Thanks in advance folks...
Book1---Excel.jpg
0
Comment
Question by:Christian Hans
3 Comments
 
LVL 29

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41852413
If both the columns have the same values and each values from column A exists in column B and assuming your data in column A starts from A2, then why not just place the following formula in B2 and copy it down?

=A2

Open in new window

0
 
LVL 32

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 41853542
Move the values from column B into another column, lets say D, then use this formula in column B:

=IFERROR(VLOOKUP($A1,D:D,1,FALSE),"")

Copy down and then copy and paste values.

Those where this is no match will be blank.
0
 
LVL 14

Expert Comment

by:frankhelk
ID: 41895626
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Rob Henson (https:#a41853542)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk
Experts-Exchange Cleanup Volunteer
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now