In which cells do you want your lookup formulae? You are showing values in
all your cells, so it is rather difficult to figure out what it is you want
to do! And yes, you can look up based on 2 values. Only, you will be using
INDEX, iso LOOKUP

"Len" wrote:

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