Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complicated query
I have multiple spreadsheets in multiple files I am trying to run IF(AND) forumlas on. EXAMPLE: I have a spreadsheet of bank transactions from multiple banks for a company: check date, check #, payee, amount. I have other spreadsheets containing the same info provided by the bank, data being divided into each spreadsheet by bank. I want to compare the spreadsheets' info for accuracy for the info provided by the company. COMPLICATION: there are not always unique identifiers assoicated with the transactions (missing check # or date) and there are duplicate check #s and amounts. TRIED: I ran vlookups to compare the check #, amount and clear date. However, since these were run separately I am getting false positives from the duplicate info. GOAL: I want to run a query that will tell me if the matches from vlookups came from one column. OR, run a query to compare "IF the check # matches, does the amount in the same column match also". Ideas? -- Btbxgirl ------------------------------------------------------------------------ Btbxgirl's Profile: http://www.excelforum.com/member.php...o&userid=36122 View this thread: http://www.excelforum.com/showthread...hreadid=558971 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems importing from an Access query | Excel Discussion (Misc queries) | |||
changing query source | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) |