Excel Vlookup Issue: Need multiple columns of vlookup data
See attached spreadsheet for example of what I am trying to do. Lookup-Issue.xls
In Range A2:A10, I have a list of building names. In columns B-K, rows 2-10, I have different levels that upgrades can be applied to these buildings.
In Range A13:A62, I have a list of all 50 levels. In Range B13:B62, I created a simple CountIf statement that counts the total number buildings of that level in Range B2:K10.
What I need is to be able to display all Building Names in columns C:K next to the total number of buildings per level. Is this possible with a VLookup? I have created static data of what I am talking about in rows 13-17.
In C13 and copied down & across,
Array formula. Confirmed with CTRL + SHIFT + ENTER