I would like to know if there is any formula for this situation.
I have Column A: account numbers. Column B: Account Balance Column C: Debits per week. This information is sorted by date. In a different spread sheet (column A)I have a list of accounts sorted in alphabetical order. I would like to match Column A, B and C in Spreadsheet #1 to the list of accounts I have in Column A spreadsheet # 2.