HELP : selectively retrieving a data from a table

[Albert Byun]

Basically, what I want to implement is as following:
**********************************************************************
Irms (current) is calculated from a formula and displayed in the following
table.

-----------------------------
| Irms | Requied Width |
-----------------------------
| | |
-----------------------------

Use this Ic value to run down a table and pick out 'Requied Width' that is
sufficient to carry that much Irms value
***********************************************************************

- Example 1 :

if Irms = 4mA

and the data table is

-------------------------
| Irms | Wire Width |
----- -----------------
| 1mA | 1x |
| 3mA | 2x |
| 5mA | 3x |
| 7mA | 4x |
-------------------------

The final table should look like this:

-----------------------------
| Irms | Requied Width |
-----------------------------
| 4 | 3x |
-----------------------------

- Example 2:

if Irms = 6mA

then the final table should look like this

-----------------------------
| Irms | Requied Width |
-----------------------------
| 6 | 4x |
-----------------------------

=>>> I need to implement this just in Excel spreadsheet not using any
external programming such as perl.

Thank you.

 

[Freemini]

You can use Vlookup for this but it will give an incorrect answer as i
will lookup the next lowest value in the table.

Thus using it in it's normal form for Ic = 4mA it will give cable siz
2.

To overcome this you will need to ensure the value it looks up i
greater and this can be achieved by adding 1.9 to the entered value
(the more 9's the more accurate it becomes)

So if your table is in cells B10:C13 and your input current is entere
into B2. Enter the following into cell C2 (answer cell)

=VLOOKUP(B2+1.9,B10:C13,2)


The other problem you will encounter is when you reach the upper limi
on cable size. To overcome this enter the next number in sequence i
B14 and in C14 enter a message like 'Over size' amend the formula abov
to include these into the lookup table and everything should work.

hth
Mik