Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v look up
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v look up
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|