complex Lists

[Dark_Lord]

hello there

Iam studying civil engineering and iam trying to make an excel sheet to calculate reinforcement required for solid slabs

to calculate the reinforcment first you should calculate positive and negative moments along short and long directions with dead and live loads

what iam trying to do is creating 2 lists the first list is to choose the RATIO of Short Span(a) divided by Long Span(b)

The Second List is to choose a case out of 9 cases of possible connections

the idea is to choose a ratio from list 1 and a case from list 2 to return the values of crossponding moments


The table is attached

i would really appreciate any help with this

Thanks