Trying to use VLOOKUP with 2 matches?

I have two columns in which I want to match BOTH columns, and then VLOOKUP would return the third column's value. But I'm not sure if this is possible...

I have attached an example:

http://www.ualberta.ca/~fqureshi/example.zip

Basically this is what I want to do:

On the right side, I have 3 columns of data. On the left, I have the area where I want to have the VLOOKUP. I want to have B6 and C6 BOTH match to something in columns H and I. So if we look in the data, matching to Rect1 & Rect2 should be 112, but if we only have the first value (like normal VLOOKUP), this doesn't work and it returns 158.

So is there a way to have the VLOOKUP check and match BOTH values before it returns a value.

(Sorry if my explanation is a bit confusing :P)

Hmm...I get a Circular formula warning....and I think you got the data mixed up :P The "Table" that I want to check is on the right side....columns H, I and J. The column I want to have the VLOOKUP in is column D. The columns that I am editting would be B and C, and I would want it to automatically fill in the correct value in D (from H, I and J).

Wow, that is pretty complicated. But unfortunately, it's not working correctly. In column J, you have a 4, and then 1s all the way down. But if you fill it with different numbers, you'll notice that it's not looking up the correct rows that match both inputs. It seems to be functioning like a single input VLOOKUP (where only the cells in column B are compared with column H)

Oh nice that works! I never would have thought of sumproduct....didn't know you could use it like that....

Thanks for your help!