mp3architect
New Member
- Joined
- Sep 8, 2014
- Messages
- 2
I have been trying to figure this out for the past few hours with little luck. I have searched through this forum but everything I have tried thus far is just shy of hitting the nail on the head. I am hoping someone can help me out.
I have a large table of many rooms:
<tbody>
</tbody>imagine this list goes on for over 200 rooms...
I want to create a table on a separate sheet that will search this information based off which zone it is in and list the rooms by zone:
ZONE 1
<tbody>
</tbody>
Zone2
<tbody>
</tbody>
Zone 3
<tbody>
</tbody>
The closest answer I have been able to find is replicating an index problem here: http://www.mrexcel.com/forum/excel-questions/546177-vlookup-find-next.html#post2696961.
I have essentially the same issue, where VLookup is perfect, and I am tryign to go to the next line in my original table to generate the new one. However, as I modify the formulas, everything goes to hell.
I am pretty good at basic excel, but very new to index functions. Any help or better direction would be greatly appreciated.
I have a large table of many rooms:
ID | Room Name | Area | Location |
RM01 | Office 1 | 300 | Zone 1 |
RM02 | Office 2 | 300 | Zone 1 |
RM03 | Office 3 | 450 | Zone 3 |
RM04 | Administration | 600 | Zone 2 |
RM05 | ******* | 200 | Zone 1 |
RM06 | Conference Room | 250 | Zone 2 |
<tbody>
</tbody>
I want to create a table on a separate sheet that will search this information based off which zone it is in and list the rooms by zone:
ZONE 1
ID | Room Name | Area |
RM01 | Office 1 | 300 |
RM02 | Office 2 | 300 |
RM05 | ******* | 200 |
<tbody>
</tbody>
Zone2
ID | Room Name | Area | Location |
RM04 | Administration | 600 | Zone 2 |
RM06 | Conference Room | 250 | Zone 2 |
<tbody>
</tbody>
Zone 3
ID | Room Name | Area | Location |
RM03 | Office 3 | 450 | Zone 3 |
<tbody>
</tbody>
The closest answer I have been able to find is replicating an index problem here: http://www.mrexcel.com/forum/excel-questions/546177-vlookup-find-next.html#post2696961.
I have essentially the same issue, where VLookup is perfect, and I am tryign to go to the next line in my original table to generate the new one. However, as I modify the formulas, everything goes to hell.
I am pretty good at basic excel, but very new to index functions. Any help or better direction would be greatly appreciated.