software

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 whe

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 --
moglione1
------------------------------------------------------------------------
moglione1's Profile: www.excelforum.com/member.php...oamp;userid=26414
View this thread: www.excelforum.com/showthread...hreadid=515426I would add an extra column that contains the values you want to search
on concatenated together, and do the lookup on that.

moglione1 wrote:
gt; Hi all,
gt;
gt; Was wondering if anybody knows if a VLOOKUP MATCH Formula can have more
gt; than 1 match criteria. The problem I have is.
gt;
gt; I would like to return the value whe
gt;
gt; Value in Row 6 = 2005 and Value of Row 7 = Sum Of Qty and match this to
gt; where the product is 336.
gt;
gt; Any ideas at all on the formula would be amazing
gt;
gt;
gt; --
gt; moglione1
gt; ------------------------------------------------------------------------
gt; moglione1's Profile: www.excelforum.com/member.php...oamp;userid=26414
gt; View this thread: www.excelforum.com/showthread...hreadid=515426