Compare two lists and return matched values, including entire row data (Index/Match?)

Hi all,

Just signed up to the forum. I have been searching everywhere online to get help on a little issue I am having and figured, what the heck, I'll join a forum. I have two lists. One contains only emails, the other contains emails, customer IDs, order IDs, etc. List 1 contains one column A (Customer Email) and List 2 contains columns A:AT (Order ID, Customer ID,Customer Name, Customer Email, etc.). I need to compare the two lists so I can see which customers have ordered more than once, so I will need to see which emails match up. (The number of rows on List 2 will be ever changing because we'll be adding more rows to it as time goes on to see if more people have ordered)

I have been able to do that with the Index/Match function, but I would like to be able to return the entire row of information from List 2. Is this possible? If so, can someone please help? Basically if an email matches, I want to be able to retrieve the Order ID, Customer ID, Customer Name, etc. for that matched email from List 2. Please let me know if anyone needs more clarification. My explanations can get a bit choppy.


Thanks!!

I am not sure about your problem.
Please take a look at the attached file to see if this is what you want.

Thanks so much for the help! It worked out well and was exactly what I needed. Is there a way I can hide all the non-matched emails? I don't want to have all the cells with #N/A visible? I know I can do it manually, but if there is a formula, it would be a lot faster.

=IFERROR(your_formula_here,"")

For some reason the IFERROR is not working for me right now, but I'm sure I made some little mistake, so I'll play around with it. Thanks!

I do have one more question. I have attached an example of what my spreadsheet looks like (not the actual data). I have used dyuk's formula and while it works great, I want to be able to show that Dana ordered twice and Zandi ordered 3 times. It doesn't matter if their order shipped or not, I just need to be able to show a list of all matched emails even if there are duplicates. Any suggestions?

Orders1.xlsx