v look up

[Donna]

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

 

[Simon Lloyd]

Donna, there must be something else wrong as VlookUp can ONLY retyr
the first match, can you give any further information


I am comparing a list of checks from our system to bank checks cleare
with
v lookup formula. My problem is when the bank has a check for $100 an
ou
system has two checks for $100, Vlookup is matching both our syste
checks t
the one bank check. Is there a way to instruct it to only match th
firs
$100.00
Donn

col c col d col
$27,444.91 27,444.91 $0.0

G H I
K
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-D1
k =+VLOOKUP($J29,$C$2:$C$55,1,FALSE
l =+J24-K24


--
Simon Lloyd

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com)

 

[Donna]

Hi,
Maybe there is a better way than a Vlookup to accomplish this.
Lets just say I have 2 columns to compare A & F. If there is a $5.00
amount in Col A then I want it to look at column F and if there is a $5.00,
put $5.00 in col B. In col C , I am using the difference between col a and
col b to find out if there is not a corresponding amount in column F. If I
only have 1 $5.00 amount in Col A, I only want it to pick up $5.00 one time.
Col A Col B Col C Col F
1 $25.00 $25.00 $5.00
2 $10.00 $10.00 $0.00 $5.00
3 $5.00 $ 5.00 $0.00 $10.00
Thanks for taking your time on this.
Donna