Hi all,

Was wondering if anybody knows if a VLOOKUP MATCH Formula can have more than 1 match criteria. The problem I have is.

I would like to return the value where:

Value in Row 6 = 2005 and Value of Row 7 = Sum Of Qty and match this to where the product is 336.

Any ideas at all on the formula would be amazing