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