- Jul 24, 2014
- Office Version
I am trying to put together a summary report where I have accounts vertically and departments horitzontally. For each intersection (dept and account), I want to create a formula that looks to that data dump - departments are listed B1:AO1 and Accounts are listed A2:A45. How do I create a forumla that scans the departments in B1:AO1 for Accounting and then pulls in the matching value for Salaries in Accounts in A2:A45?