Cyril,
Lets say that A1:E3 houses the following sample data and you want to retrieve the value from val2 column of this table, which is associated with lookup values in G2 (a date) and H2 (a digit code).
{"date","code","val1","val2","val3";
37258,"023",3,4,5;
37258,"024",6,45,8}
Strange looking numbers are just dates in the internal representation that Excel uses for dates.
In G2 we have: 1/2/02
In H2 we have: 024
In I2 enter:
=IF(SUMPRODUCT(ISNUMBER(MATCH(G2&H2,$A$2:$A$3&$B$2:$B$3,0))+0),INDEX($D$2:$D$3,SUMPRODUCT(MATCH(G2&H2,$A$2:$A$3&$B$2:$B$3,0))),"")
where $D$2:$D$3 in INDEX is the column from which we want to retrieve the associated value.
Note. If you're going to use this formula in lots of cells, it will incur some performance costs.
Aladin
Like this thread? Share it with others