I am comparing a list of checks from our system to bank checks cleared with a
v lookup formula. My problem is when the bank has a check for $100 and our
system has two checks for $100, Vlookup is matching both our system checks to
the one bank check. Is there a way to instruct it to only match the first
$100.00?
Donna

col c col d col e
$27,444.91 27,444.91 $0.00

G H I J
K L
15 2/13/2010 15.10100.00 27,444.91 27,444.91 -

Formulas: in col d =+VLOOKUP($C15,$J$2:$J$76,1,FALSE)
col e =C15-D15
k =+VLOOKUP($J29,$C$2:$C$55,1,FALSE)
l =+J24-K24