Get instant live expert help on match column a with column b

“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

i need to match data in column b with data in column d using column a as the reference. basically, column a and b match, but i need the data in column b to be lined up with the correct data in column d.
Solved by A. H. in 23 mins
Need to match each cell value in column A with Column B and give result. Problem is i do not want exact match. Only need to look whether column B contains any part of the value in column A
Solved by Z. B. in 27 mins
Need to match Account Numbers in Column A with Site IDs in Column B.
Solved by O. W. in 25 mins
I need a formula to match values in excel. For example, I have Column A with 100 unique product names and Column B with 1000 unique product names some which are in Column A as well. Column A has Price information and Column B has Unit Count. I'd like to match all the products from Column B to Column A so there 100 products that match on Price and Unit Count. How do I do this?
Solved by I. D. in 26 mins
1.) If REQUESTOR PROFILES Column D does NOT have a match in ENROLLED Column C, populate REQUESTOR PROFILES Column A with NO 2.) If REQUESTOR PROFILES Column A is NO and REQUESTOR PROFILES Column D and ETFs Column B match populate REQUESTOR PROFILES Column F with ETFs Column C
Solved by E. S. in 27 mins