sixsteps268
New Member
- Joined
- May 9, 2013
- Messages
- 15
I've been searching for about an hour can't find an answer so I'm posting a new thread. I'd love any help you guys can provide me.
I am working on some analysis that compares sales to returns.
I have a workbook with a sales sheet that contains Order ID #'s and Sku #'s. Then I have a returns sheet in the same workbook that contains Order ID #'s and Sku #'s.
Some Order ID #'s are single SKU orders, some are not. I have many instances of multiple sku orders where only 1 SKU was returned and not the whole order.
A simple vlookup returns if the order shows up as being returned, but I can't seem to figure out how to return a value if both the order and the sku is returned.
I can't quite get the logic to work. It's like if the order is returned and if the sku of that same order is returned, then return the value.
Does that make sense?
I am working on some analysis that compares sales to returns.
I have a workbook with a sales sheet that contains Order ID #'s and Sku #'s. Then I have a returns sheet in the same workbook that contains Order ID #'s and Sku #'s.
Some Order ID #'s are single SKU orders, some are not. I have many instances of multiple sku orders where only 1 SKU was returned and not the whole order.
A simple vlookup returns if the order shows up as being returned, but I can't seem to figure out how to return a value if both the order and the sku is returned.
I can't quite get the logic to work. It's like if the order is returned and if the sku of that same order is returned, then return the value.
Does that make sense?