asked on Excel Vlookup Issue: Need multiple columns of vlookup data
Hi Experts,
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.
Any help would be greatly appreciated!
Regards,
Rob
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.
Any help would be greatly appreciated!
Regards,
Rob
Microsoft Excel
Last Comment
krishnakrkc
ASKER
Hi Kris,
Thank you for your comment. When I put that formula into C13, it returns "#VALUE!" for some reason.. It says that there might be a circular reference.. Do you know why this might be for me?
Rob
Thank you for your comment. When I put that formula into C13, it returns "#VALUE!" for some reason.. It says that there might be a circular reference.. Do you know why this might be for me?
Rob
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi ltsweb,
That will actually do for what I need :) I finished the remaining columns and it worked and is simple to understand.
Thanks!
Rob
That will actually do for what I need :) I finished the remaining columns and it worked and is simple to understand.
Thanks!
Rob
Great Rob!
I have to say, I liked the other solution from Kris, but I couldn't get it to work either! I am glad the simple solution worked for you!
Regards!
I have to say, I liked the other solution from Kris, but I couldn't get it to work either! I am glad the simple solution worked for you!
Regards!
In C13 and copied down & across,
=IF(COLUMNS($C13:C13)<=$B1
Array formula. Confirmed with CTRL + SHIFT + ENTER
Kris