VLOOKUP using two criteria

[andrewc]

Hi,

I have data organised as follows:

Column A: Date
Column B: Fund Name
Column C: Fund Value

In D1 I have the phrase “Fund A”, in E1 I have the date 31/08/2009 and in F1 I would like to create a VLOOKUP formula that looks in the range A:C and returns the value of Fund A on 31/08/2009. Fund A has a value for many other dates too so the VLOOKUP would have to be able to accommodate both criteria.

Can someone please help!

Thanks!