Need a VLookup formula for Multiple Columns

I know this is simple but my brain is not working right now. Need a vlook up for this. If the data in cells from Column A matches Column E & the data in cells from Column B Matches F then return the data from cells in column G to cells in Column D. IF A & B don't match E & F then return 0. Can someone help? Example below:

A B C D E F G
BLUE RED 4 BLUE RED 8
GREEN BLUE 8 GREEN PURPLE 16

attachment ATTACH]281633[/ATTACH]

try this in cell D2 then copy down

=IF(AND(A2=E2,B2=F2),G2,0)

but, you have a {space bar} insert after the first "red" in cell B2, with the "space" there it will return a 0 instead of whats in cell G2

Worked perfectly - thank you! Thanks for catching my error.

Thought It worked but I may still need the vlookup, not sure. Here is the updated attachment. The match may not always be in the same row, so thats why I think I need the vlookup. Here is the updated file. Can you still help? Trying to get the 2012 data to match up next to the 2013 data, however, there may not always be data for 2012 so it would return zero. For the data in G to populate the cells in column D, A&B and E&F would still have to match.

I Don't understand how you can match the 2012 Data against the 2013 data without the coulours being aligned.

(ie. Blue Red 4 0 Orange Pink 10) I think you can only match them together if Blue Red for 2012 was aligned to the 2013 Data as well...

maybe im not understanding what your needing. please re upload the sheet with samples of what it should be and should not be.. it would be easier to build the formula.. the sample you just uploaded would result in 0's in all D column

Thanks for looking into this. In the file, row 3 A & B match row 8 E & F so the formula would return 8 from G8 to D3. I want the formula to search the range E3:G9 and return the 2012 value to column D. It makes since in my head. The colors are just examples of matching data. Thanks for the help.

I started with a regular vlookup VLOOKUP(A3,E3:G9,3,FALSE), but it only matches data in Column A with data in column E. I need it to match data in A&B with E&F within that range.

thanks anyway, I figured it out using a Index/Match formula.