Lookup Value from the range and convert into another unit

[ajmal pottekattil yoousuf]

Lookup value From the value from the range table 

[#2]

Its called Excel CONVERT Function you can use it . You would be able to convert measuring unit
Syntax
=CONVERT (number, from_unit, to_unit)

Please refer the below link for more info

https://exceljet.net/excel-functions/excel-convert-function

[#3 · Accepted solution]

That could be like

=INDEX(Sheet0!$F$111:$F$120,
     MATCH(1,INDEX(
        ($B7*(($C7="µA")*0.000001+($C7="mA")*0.001+($C7="A"))>=Sheet0!$B$111:$B$120*((Sheet0!$C$111:$C$120="µA")*0.000001+(Sheet0!$C$111:$C$120="mA")*0.001+(Sheet0!$C$111:$C$120="A")))*
       ($B7*(($C7="µA")*0.000001+($C7="mA")*0.001+($C7="A"))<=Sheet0!$D$111:$D$120*((Sheet0!$E$111:$E$120="µA")*0.000001+(Sheet0!$E$111:$E$120="mA")*0.001+(Sheet0!$E$111:$E$120="A"))),
0,),))

but much better to convert ranges into excel tables and add helper columns to adjust units. Please see attached

[#4]

Thankyou very much 

Sir I want Ac current lookup

and CMC two 

[#5]

For AC Current CMC depends on frequency, not only on AC Current range values. And you have no frequency in your input.

[#6]

ok sir 

This formula is applicable to "DC Voltage",Frequency,Capacitance,

In AC Current and AC Voltage How we lookup

[#7]

@Sergei Baklan 

How to find the CMC1 and CMC2 based on the AC Voltage and Frequency.

I attached the video for reference.