Hi,

How to solve a problem in vlookup formula if the lookup value is not an
unique number ?
e.g.
Sheet1
A B C D
1 01/03/2005 Miscellaneous Debit 100.00
2 01/03/2005 Miscellaneous Debit 9,006.30
3 15/03/2005 Cheques Debit 100.00
4 24/03/2005 Miscellaneous Debit 20.00
5 25/03/2005 Miscellaneous Debit 2,000.00

Sheet2
A B C D
1 9,006.30 100050 01/03/2005 GLP5-00696
2 100.00 100050 01/03/2005 GLP5-00697
3 20.00 600045 24/03/2005 GLP5-00699
4 2,000.00 155652 25/03/2005 GLP5-00652
5 3,350.00 155654 25/03/2005 GLP5-00654


If lookup value in Sheet1 is cell D1 = 100.00, the
vlookup(D1,Sheet2!$A$1:$C$5,1,FALSE) = 100.00
however, the vlookup formula will not give the correct result
especially if the lookup value in Sheet1 for cell D3 = 100.00, ie the
result still 100.00 as the value in A2 of Sheet2 is matched against the
value in D3 = 100.00 of Sheet1 where the
vlookup(D3,Sheet2!$A$1:$C$5,1,FALSE)= 100.00

Is there anyway to lookup 2 values at the same time, 1st value is the
value in D3 and the 2nd value is the date in A3, then apply the vlookup
formula ?
Lookup value Lookup Date Vlookup formula
a)D1 = 100.00 A1 = 01/03/2005 Result = 100.00 in Sheet2
in Sheet1 in Sheet1 (ie A2=100,C2=01/03/2005)

b)D2 = 9,006.30 A2 = 01/03/2005 Result = 9,006.30 in Sheet2
in Sheet1 in Sheet1 (ie A1=9,006.30,C1=01/03/2005)

c)D3 = 100.00 A3 = 15/03/2005 Result = Nil in Sheet2
in Sheet1 in Sheet1 (ie A1=100.00,C1=01/03/2005 not
matched)

kindly assist me to set a Excel formula or VBA code to find 2 lookup
values at the same time to solve the above problem

Thanks
Regards
Len