Need help with a formula requiring multiple lookups/matches with 1 result.
I have a table listing by columns the following
B=Motor kW (up to 5 variations per identicle kW rating)
E=Max' cable dist for DOL
F=Max' cable dist for VSD
G=Cable mm2 req' (up to 5 options based on run length/kW rating)
H=No. of cables in parrallel req' (1, 2, or 3)

I have a load list of 100's of various motors of different kW ratings
stating drive type (DOL or VSD)
and I have a field to enter in estimated cable run length

I want to be able to type in the Est' run length and have the formula select
the right
cable mm2 (Column G) & No. of (Column H) based on kW, DOL /VSD, Est Run Length