Horizontal and Vertical Vlookups?

[mattyblueice]

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?

Thanks!

 

[bbott]

Use the INDEX function with MATCH functions as the second and third arguments.

Take a look at the exact match matrix example here:

https://www.linkedin.com/pulse/excel-essentials-automating-matrix-brian-bott?trk=mp-author-card

 

[Matty]

Could you provide a small example to make sure we're going down the right path?

Matty

 

[mattyblueice]

Use the INDEX function with MATCH functions as the second and third arguments.

Take a look at the exact match matrix example here:

https://www.linkedin.com/pulse/excel-essentials-automating-matrix-brian-bott?trk=mp-author-card

That worked! Thank you very much! :-0

 

[bbott]

That worked! Thank you very much! :-0

You're welcome.