Cross Referencing Two Lists By Column with E-mail, Trying to Combine and Add Columns

[dogtopia]

Hello,

Thank you all in advance for any help with this.

I have two lists of my customers, they contain some of the same information but they also contain different columns with valuable information. The lists are not equal in size, one has 1000 and one has 200 enteries.

The commone thread is the column with e-mail addresses. I want to work with the shorter list of 200 by using the e-mail column and add the columns of information from the list of 1000. Is there a way for me to remove the rows from the list of 1000 that do not have matching e-mail addresses with the list of 200? If I get those removed I ca then just sort alphabetically and the columns should line up. Is there another way to skin this cat?

Thanks

[shank_mis]

Hi @dogtopia,

I am afraid you may not be able to remove any entries with the formula. However, what you can do is generate a new list with desired entries and columns.
We may come up with a feasible solution provided you upload an excel sheet or snap shot of the dataset you have and what is the outcome you are expecting.

Note: If you want to completely delete an entry, VBA might come handy in this task. However, I am not sure about it.

[alansidman]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Ulnarian]

It's hard to describe over text, but, take a look at the formula on this site. If you haven't seen this before (and if you work with Excel often), really spend some time with this as it will save you countless hours when you need to run comparisons. But, it is kinda hard to say if it will help you exactly without some type of sample (I think it will though )

Link to site: https://support.office.com/en-us/art...f-50fc19d85dcc

You just need to look at example one, no need for the VBA stuff on the site