A vlookup/index-match type problem
Thanks very much for your help. Unfortunately I could not get any of your
solutions to work for. In the end I created a helper column which basically
took the square root of the account number and added the date to get a
unique identifier and then used this in a straightforward index/match
function.
Cheers anyway,
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
|