Hi,

why don't you show us a sample data layout. Show us what you want to enter
in this Est run length and what you expect to get back based on your sample.

In general we do this type of thing with VLOOLKUP, MATCH, LOOKUP, sometimes
SUMPRODUCT, FIND, SEARCH.... but it all depends on the details. For example
what is a Est run length - an measurement in feet, and duration in time. If
its only and estimate how do you want Excel to decide what results to return,
for example assuming there is no such run length?
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"G, Formby" wrote:

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