Forum Discussion
ajmal_pottekattil_yoousuf
Dec 17, 2018Iron Contributor
Lookup Value from the range and convert into another unit
Lookup value From the value from the range table
- Dec 17, 2018
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
ajmal_pottekattil_yoousuf
Iron Contributor
I use Excel 2019 version.
SergeiBaklan
Mar 11, 2023MVP
Sorry, can't help when, perhaps someone else