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