Hello,
I have a chart set up as following... (Chart 1)
B C D E F G H I
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
In Chart 2 for "Fiber #" I enter a number between 1-1728, for "ML" I have a drop down list. When I select a ML from the drop down list it returns the corresponding "Frame" from Chart 1. This part I have figured out. Where I am having trouble is the "Chassis". I need a formula that return the corresponding Chassis the "Fiber #" falls in.
Example:
<tbody>
</tbody>
I have a 3rd chart that returns the "Tray" & "Port" values, which I figured out as well. Just need help with the "Chassis".
I have a chart set up as following... (Chart 1)
B C D E F G H I
ML | Frame | Chassis 1 | Chassis 2 | Chassis 3 | Chassis 4 | Chassis 5 | Chassis 6 |
ML1 | Frame 1 | 1-576 | 577-1152 | 1153-1728 | |||
ML2 | Frame 2 | 1-576 | 577-1152 | 1153-1728 | |||
ML3 | Frame 4 | 1-576 | 577-1152 | 1153-1728 | |||
ML4 | Frame 3 | 1-576 | 577-864 | ||||
ML5 | Frame 1 | 1-576 | 577-864 | ||||
ML6 | Frame 3 | 1-576 | 577-864 |
<tbody>
</tbody>
Another chart that looks like this... (Chart 2) |
<tbody>
</tbody>
Fiber # | ML | Frame | Chassis | Tray | Port |
<tbody>
</tbody>
In Chart 2 for "Fiber #" I enter a number between 1-1728, for "ML" I have a drop down list. When I select a ML from the drop down list it returns the corresponding "Frame" from Chart 1. This part I have figured out. Where I am having trouble is the "Chassis". I need a formula that return the corresponding Chassis the "Fiber #" falls in.
Example:
Fiber # | ML | Frame | Chassis | Tray | Port |
782 | ML3 | Frame 4 | Chassis 2 |
<tbody>
</tbody>
I have a 3rd chart that returns the "Tray" & "Port" values, which I figured out as well. Just need help with the "Chassis".