hi,
anyone to solve my problem ?

I have an Abacus that contain :

Cell B1 to R1 contain (CABLE SIZE):

4mm, 6mm, 10mm, 16mm, 25mm, 35mm, 50mm, 70mm, 95mm, 120mm, 150mm,
185mm, 2x70mm, 2x95mm, 2x120mm, 2x150mm and 2x185mm

Cell A2 to A20 contain (POWER):
0.4kw, 0.75kw, 1.5kw, 2.2kw, 3.7kw, 5.5kw, 7.5kw, 11kw, 15kw, 18.5kw,
22kw, 30kw, 37kw, 45kw, 55kw, 89kw, 90kw, 110kw, 132kw

Cell B2 to R20 contain a number (Maximum Length).


How can I find the "CABLE SIZE" (Cell B1 to R1) if I have a POWER and a
LENGTH?

PS, the LENGTH I have his not a value in the table, so I want to take
the above one.

Regards


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=468135

Hi Herve,

Try this solution:

Place under your table these cells (to input POWER and LENGTH values you
have and for the CABLE SIZE you want to get):

A22: POWER: B22: type in your value
A23: LENGTH: B23: type in your value
A24: CABLE SIZE: B24: =INDEX(A1:Q20;1;D23) (Your result)

Place these formulas to helper cells:

C22: =MATCH(B22;R2:R20;0)+1
C23: =MATCH(B23;INDIRECT(D22);1)+IF(ISNA(MATCH(B23;INDI RECT(D22);0));2;1)
D22: ="B"&C22&":"&"Q"&C22

The values in cells B2:Q2, B3:Q3, ... B20:Q20 must be in ascending order in
each separate rows.

Regards,
Stefi


€žherve€� ezt Ã*rta:


hi,
anyone to solve my problem ?

I have an Abacus that contain :

Cell B1 to R1 contain (CABLE SIZE):

4mm, 6mm, 10mm, 16mm, 25mm, 35mm, 50mm, 70mm, 95mm, 120mm, 150mm,
185mm, 2x70mm, 2x95mm, 2x120mm, 2x150mm and 2x185mm

Cell A2 to A20 contain (POWER):
0.4kw, 0.75kw, 1.5kw, 2.2kw, 3.7kw, 5.5kw, 7.5kw, 11kw, 15kw, 18.5kw,
22kw, 30kw, 37kw, 45kw, 55kw, 89kw, 90kw, 110kw, 132kw

Cell B2 to R20 contain a number (Maximum Length).


How can I find the "CABLE SIZE" (Cell B1 to R1) if I have a POWER and a
LENGTH?

PS, the LENGTH I have his not a value in the table, so I want to take
the above one.

Regards


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=468135