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
Thuyavan Ganesan
Dec 17, 2018Steel Contributor
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
Syntax
=CONVERT (number, from_unit, to_unit)
Please refer the below link for more info
https://exceljet.net/excel-functions/excel-convert-function