Vlookup between multiple criteria and then yes or no match

I want to look up prices for styles based on which store they are in (field or house). The prices are different for both.

For example, I want style 2012 price to bring back the price, but I want to make sure I am pulling in field, 2012, and the price. 

THEN I want to see if that price matches the price for the store and stlye in another worksheet and be able to pull back a “yes” or “no”

 

Thank you

 

By: Jenny

Leave a Reply

Your email address will not be published. Required fields are marked *