hi
im looking for a formula that will let me look up two values in one table
array and return one value.
For example: How would i look up a numerical value for product c that is in
the column for 15/01/08

DATE
01/01/08 08/01/08 15/01/08 22/01/08 29/01/08
product a
product b
product c
product d
product e

Ive tried Vlookup with a Hlookup in it and it only searches based on one
criteria. The table will be very large, from colum b to cl and rows 42 to 374.

Any help with this will be greatly appreciated as i have been working on it
for a few weeks and made no headway.