A vlookup/index-match type problem
Is your dates in col B are in Date format ?
On Oct 23, 4:33*pm, "Andrew Mackenzie"
wrote:
Thaaks for your help guys but all three solutions reurn #N/A. *Definitely
entered as an array.
Any other ideas, the life is slowly being sapped out of me at the moment!
Cheers,
Andrew
"Andrew Mackenzie" wrote in message
...
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
|