Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

What if their positions are not same This is the situation : The first sheet contains all products while the second sheet contains the sold products in a month. So, ID 001 could appear more than once in sheet2. I need to make sure if every ID is sold with the correct price based on the PRICE column in sheet1.