Return a value based upon two variables

I am trying to return a value based upon two variables.

On Sheet 1, A7 and A8 are variables based upon customer input. The pricing for these two variables are on Sheet 2 column E. I need to have Sheet 1 C8 reflect the value pulled from Sheet 2 column E

Sheet 1
-------A--------B---------C
7---Jeans
8---Blue


Sheet 2
-------A--------B-------E
12---Jeans---Red----1111
37---Jeans--Green---2222
85---Jeans----Blue----3333
97---Slacks---Green--4444
100--Slacks---Blue----5555

Sheet 1 C8 should be 3333.

I tried to make a formula that I thought would work:

=INDEX(Sheet2!E$1:E$100,MATCH(1,INDEX((A7=Sheet2!A$1:A$100)*(A8=Sheet2!B$1:B$100),0),0))

I am getting a #N/A in C8 so something is not right.

Any help would be greatly appreciated.

Could you do something like this? Add a cheater column D to combine the data in the 2 rows on Sheet1. Then on the price sheet, also add a cheater column to do the same and pull in the price Sheet2(E & F). Then you can do a vlookup.

Never mind I figured it out. I had some cell merging going on.