[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

Excel Forula to line up matching cells

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
Christian Hans
Asked:
Christian Hans
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
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
 
Rob HensonFinance AnalystCommented:
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
 
frankhelkCommented:
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now