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