"Jack" wrote:

I'm trying to do a multiple lookup - my table looks like the following


Date Type 12 24 36
12/1/2008 1 .10 .12 .14
12/1/2008 2 .15 .18 .19
1/1/2009 1 .11 .13 .15
1/1/2009 2 .20 .23 .24


I need to lookup based on information in three cells
Date 12/05/08 - select 12/1 vs 1/1 row
Type 2
months 24 select the column

result would be .18