Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting matched columns
I am trying to match a cleared check statement from a bank to a check
register by check number. I want it to auto sort cleared check #, cleared date, and cleared amount to match side by side to the check register by check number. What is the best way to proceed with this task? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting matched columns
Shiela
I realize that you have a bank statement and you have an Excel sheet. Tell us what you will enter into the Excel sheet (this is in this cell, that is in that cell, etc). Then tell us what you want Excel to do with that data. HTH Otto "Shiela" wrote in message ... I am trying to match a cleared check statement from a bank to a check register by check number. I want it to auto sort cleared check #, cleared date, and cleared amount to match side by side to the check register by check number. What is the best way to proceed with this task? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting matched columns
Hi,
Rather than sorting you might consider VLOOKUP(A1,ClearedChecks,2,FALSE) In the above example A1 would contain the Check# in the register. ClearedChecks is the range where all your cleared checks are located with the check numbers in the left-most column. 2 tells VLOOKUP that you want to return the value of the second column of the ClearedCheck range when a match is found for the check number. You could do others for column 3 and 4 to return other info. False means this is an exact match we are checking for. If nothing is found NA will be returned. If this helps, please click the Yes button Cheers, Shane Devenshire "Shiela" wrote: I am trying to match a cleared check statement from a bank to a check register by check number. I want it to auto sort cleared check #, cleared date, and cleared amount to match side by side to the check register by check number. What is the best way to proceed with this task? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How matchup many IDdata- find matched IDdata in long columns | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
Sorting two columns | Excel Worksheet Functions | |||
Copying matched criteria plus relevant columns to new worksheet | Excel Discussion (Misc queries) | |||
Sorting Columns | Excel Worksheet Functions |