Dec 17 2018 11:36 AM
Dec 17 2018 01:53 PM
SolutionThat 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
Dec 18 2018 09:18 AM
Thankyou very much
Sir I want Ac current lookup
and CMC two
Dec 18 2018 09:26 AM
For AC Current CMC depends on frequency, not only on AC Current range values. And you have no frequency in your input.
Dec 19 2018 07:52 AM
ok sir
This formula is applicable to "DC Voltage",Frequency,Capacitance,
In AC Current and AC Voltage How we lookup
Dec 12 2022 09:12 PM
How to find the CMC1 and CMC2 based on the AC Voltage and Frequency.
I attached the video for reference.