VLOOKUP based on two cells

Hi,

I have a spreadsheet that looks like this: (bear in mind, the "|" is the edge of the column

NAME       | COLOR | FABRIC | METRES | TOTAL METRES
MAXI DRESS | RED   | COTTON | 1.5    | =SUM(VLOOKUP($A2,Quantities,27,0))*D2
MAXI DRESS | BLUE  | COTTON | 1.5    | =SUM(VLOOKUP($A3,Quantities,27,0))*D3

Then I have another sheet called Quantities which a similar structure..

The VLOOKUP works, but if I have a duplicate name, like in the above table "MAXI DRESS" - the formulas get confused.

How can I make my VLOOKUP take into account the NAME and the COLOR when it's looking up Quantities?