Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checks, Matching and deleting numbers
I have two spreadsheets both with check numbers, one of the spreadsheets has
outstanding checks and the other has checks that are clearing. I would like to be able to do an import function where if the certain check number is on the clearing list it deletes the one on the checks that are outstanding. Also there are a bunch of checks not just one. So I would like to do a function such as check 218, 219, 230, 235 is clearing and they are also listed on the checks page those numbers would be replaced by a 1. and if there is a check that is clearing but doesnt appear to be on the checks page I would get an error. If anyone has an idea how to do this and can help me, THANK YOU! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checks, Matching and deleting numbers
Hi,
Try this: =IF(ISNA(VLOOKUP(sheet1!A1,Sheet2!$A$1:$A$100,1,fa lse)),1,IF(Sheet1!B1=VLOOKUP(sheet1!A1,sheet2!$A$1 :$B$100,2,false),2,3) assumed your cheque#s are in column A and the amounts are in column B in both sheets and the formula results return the numbers 1, 2 or 3 which: 1 means this cheque# is not in other sheet 2 means this cheque# is completely match with the other sheet 3 means this cheque# is in other sheet but the amount does not match Thanks, -- Farhad Hodjat "Schwimms" wrote: I have two spreadsheets both with check numbers, one of the spreadsheets has outstanding checks and the other has checks that are clearing. I would like to be able to do an import function where if the certain check number is on the clearing list it deletes the one on the checks that are outstanding. Also there are a bunch of checks not just one. So I would like to do a function such as check 218, 219, 230, 235 is clearing and they are also listed on the checks page those numbers would be replaced by a 1. and if there is a check that is clearing but doesnt appear to be on the checks page I would get an error. If anyone has an idea how to do this and can help me, THANK YOU! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Checks, Matching and deleting numbers
Thanks Farhad, I think that formula will work great. Just need to put it into
my sheet so that it correctly corresponds to the right sheets and columns. I have another one for you if you feel up to it. OK, so I have a spreadsheet containing a list of Treasury bills that are split into codes. My goal is to be able to punch these bills in there without having to insert cells in between dates and codes by creating another sheet that will auto insert the treasury bills into the right code and then into the right date. So let me explain the details. On the created sheet there is a bank code cell, a maturity date cell, a cost cell, and a par value cell. The bank code is something such as 826-c, nym- 000, or cotton-c...etc. I want to be able to type into the bank code cell the right code, then into the maturity date cell, the rest of the information, and then it will correctly take that information and push it into an unmade row containing all that information. If that makes sense and you know how to fix it, Great! -THANKS "Schwimms" wrote: I have two spreadsheets both with check numbers, one of the spreadsheets has outstanding checks and the other has checks that are clearing. I would like to be able to do an import function where if the certain check number is on the clearing list it deletes the one on the checks that are outstanding. Also there are a bunch of checks not just one. So I would like to do a function such as check 218, 219, 230, 235 is clearing and they are also listed on the checks page those numbers would be replaced by a 1. and if there is a check that is clearing but doesnt appear to be on the checks page I would get an error. If anyone has an idea how to do this and can help me, THANK YOU! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching a combination of numbers | Excel Discussion (Misc queries) | |||
matching and deleting | Excel Discussion (Misc queries) | |||
How do I convert numbers to words writing checks with Excel? | Excel Worksheet Functions | |||
matching numbers in col a and col b | Excel Worksheet Functions | |||
How do I spell numbers as words for writing checks in Excel? | Excel Worksheet Functions |