Pull data considering multiple criterias|Dashboards & Charts|Excel Forum|My Online Training Hub

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...