VLOOKUP using two criteria

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!

A VLOOKUP won't suffice here (unless you create a concatenation column of A & B) so:

Please Login or Register  to view this content.

change ranges to suit but keep to min.