When I try to do an index-match lookup with 2 conditions, I always get a #Value! error even though I seem to be doing everything about in the exact same way as every excel tutorial out there.

Need it for a file with over 400'000 rows, so anything manual isn't really an option. Any advice? Thanks a million in advance!

*Table 1*  

**X1 X2 Y**  

Apple 01.05.2010 CHF 10  

Apple 30.02.2010 CHF 15  

Mango 20.01.2008 CHF 5  

Mango 10.12.2011 CHF 4  

… … … 

*Table 2*  

**X1 X2 Y** 

Apple 01.05.2010 #VALUE! 

Formula in field Y of Table 2:

```
=INDEX(D4:D7;MATCH(H4&I4;B4:B7&C4:C7;0))                        

```

![See picture example here](https://i.stack.imgur.com/CjwR8.png)