Forgot to mention:-

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike

"Mike H" wrote:

Hi,

=INDEX(C1:C5,MATCH(1,(A1:A5=12345)*(B1:B5=DATE(200 9,5,18)),0))

In practice I'd use cell references for the lookup values

Mike

"Andrew Mackenzie" wrote:

Hi all,

I hope someone can help me with this. I want to return a value from a table
which is based upon two criteria. I have a table like this:

A B C
Account No. Date Balance
12345 23-4-09 100
56847 18-5-09 50
12345 18-5-09 75
32654 30-6-09 125

I want to do something like =VLOOKUP((A2 and B2:B5=18-5-09),A2:C5,3,FALSE)
to return 75.

Thanks in advance and regards,

Andrew




.