I believe there is a formula out there to solve this. I have two products list in column A and D of sheet1. Each product in column A and D has a corresponding sales number (i.e. number sold per product).
I need a formula to lookup both column A and D, check if the product in A exist in D, and then sum (or add) their sales values in column H of sheet 1. If the product in column A is not found in D, we still need to extract the product sales value in column A into H.
Note: Column G contains the unique Products list.
For example, if column A, cell A2 contains a product (Acai and the product sales value is 40) that is not found in column D products list, the sales value for “Acai” in cell H2 is 40.
See attached Excel sample workbook for your convenience. The values in cloumn G and H is the desired outcome - driven by formula.
Thanks in advance for your assistance.
Bookmarks