Excel Lookup MATCH formula

M

moglione1

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 :)
 
Top