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 senarios for same kW rating based on the following)
E=Max' cable dist for DOL
F=Max' cable dist for VSD
G=Cable mm2 req' (up to 5 options dependant 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
The type of drive is defined as (DOL or VSD)
and I have a currently blank field to enter in estimated cable run length

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