September 12, 2020
Hello To All:
I need your help on this, in the attached file I need to pull the "Actual Units Purchased" into the cell S1527 from the MTD Tab, In this case we purchased two vehicles from the same product, based on this the result should be "2"
I'm adding 4 categories named "Code A","Code B","Code C" or "Code D" in "IM" Tab and the same categories in the MTD Tab.
So the formula should be doing something like this:
Go and find and count "Code A" in "MTD" Tab and in case that you don't find nothing, go and find "Code B", etc
Same situation with the Price (T1527) we need to pull the price for the corresponding to "Code A","Code B" etc...
October 5, 2010
No file attached.
Instructions on attaching files