PinPinPoola
New Member
- Joined
- Aug 17, 2021
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hello,
I have a workbook with 2 tabs. Cabinets and Equipment.
Cabinets has a single row per cabinet
Equipment has multiple rows per cabinet
For each Cabinet Name in the Cabinets Tab, I need to evaluate all rows of the Cabinet Name in Equipment Tab and return into the Contains Equipment Owned By of Cabinets Tab if the the owner is either "Network Ops", "IT Ops" or "Shared" - where shared cabinets contain equipment owner by both Network Ops AND IT Ops.
I have tried an XLOOKUP, but this only returns the first Equipment Owner encountered for each Cabinet Name in the Equipment tab.
Cabinets Tab
Equipment Tab
Any help, advice or pointers will be greatly appreciated.
Thx
Pin
I have a workbook with 2 tabs. Cabinets and Equipment.
Cabinets has a single row per cabinet
Equipment has multiple rows per cabinet
For each Cabinet Name in the Cabinets Tab, I need to evaluate all rows of the Cabinet Name in Equipment Tab and return into the Contains Equipment Owned By of Cabinets Tab if the the owner is either "Network Ops", "IT Ops" or "Shared" - where shared cabinets contain equipment owner by both Network Ops AND IT Ops.
I have tried an XLOOKUP, but this only returns the first Equipment Owner encountered for each Cabinet Name in the Equipment tab.
Cabinets Tab
Cabinet ID | Cabinet Name | Contains Equipment Owned By | Cabinet Size |
---|---|---|---|
1 | AA01 | Network Ops | 48U 800x1200 HPE Adv Rack |
2 | AA02 | Shared | 48U 800x1200 HPE Adv Rack |
3 | AA03 | IT Ops | 48U 800x1200 HPE Adv Rack |
Equipment Tab
Equipment ID | Cabinet Name | Equipment Owner | Equipment |
---|---|---|---|
1 | AA01 | Network Ops | Cisco Switch |
2 | AA01 | Network Ops | Cisco Switch |
3 | AA01 | Network Ops | Cisco Router |
4 | AA01 | Network Ops | Cisco Firewall |
5 | AA02 | Network Ops | Cisco Switch |
6 | AA02 | Network Ops | Cisco Switch |
7 | AA02 | IT Ops | HPE ProLiant Server |
8 | AA02 | IT Ops | HPE ProLiant Server |
9 | AA02 | IT Ops | HPE ProLiant Server |
10 | AA02 | IT Ops | HPE SAN Storage |
11 | AA02 | Network Ops | HPE SAN Switch |
12 | AA02 | Network Ops | HPE SAN Switch |
13 | AA03 | IT Ops | HPE ProLiant Server |
14 | AA03 | IT Ops | HPE ProLiant Server |
Any help, advice or pointers will be greatly appreciated.
Thx
Pin