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!!