Get instant live expert help on I need help with comparing list in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Comparing two lists to see if person is on second list
Solved by A. D. in 20 mins
I need to understand vlookup and comparing two different sheets in excel
Solved by B. E. in 30 mins
Vlookup help, I am trying to create a vlookup to see if people in our database have moved company by comparing our contacts to our LinkedIn list
Solved by D. F. in 25 mins
I need a formula to pull the below information. I have A1 and A2 in Excel 1 then B1 and B2 in Excel 2 which is exact match and I need to pull B3 as result in Excel 1 comparing these cells. Eg: If I have Name and Class in Excel 1 and Name and Class in Excel 2 I need Marks to Excel 1 comparing both. Please help
Solved by I. J. in 27 mins
Hi. I have list A that I am comparing with list B. I want to see which people from list A are in list B. I started with a "CountIf" formula. I made the range all of list B, and the criteria each name in list B. I put a "$" sign in front of the range so it would remain constant, but it doesn't work. Please help!
Solved by S. A. in 22 mins