Forum Discussion
Convert one Unit to Another
If use lookup vector sorted in ascending order and adjust result vector accordingly, simple LOOKUP(), which is available for any version, works
=F5*LOOKUP(G5&"-"&D5,{"µA-A","µA-mA","A-µA","A-A","A-mA","mA-µA","mA-A","mA-mA","μm-μm"},{0.000001,0.001,0.000001,1,0.001,1000,0.001,1,1})
CONVERT function
Link: How to Use CONVERT
Ampere is not part of the measurement systems supported by CONVERT().
=F5*XLOOKUP(G5&"-"&D5,{"μm-μm","µA-mA","µA-A","mA-µA","mA-mA","mA-A","A-µA","A-mA","A-A"},{1,0.001,0.000001,1000,1,0.001,0.000001,0.001;1})
That's what happens when you're not careful, number is not the same number.
Thanks hadn't thought of that and thanks for the help.
Also my apologies to Mr. ajmal pottekattil yoousuf for his time wasting.
Recommend using Mr. Detlef_Lewin formula, although I haven't tried it.
The formula is for Excel 365 or 2019, I'm currently working on a 2016 version.
Thx again.
If use lookup vector sorted in ascending order and adjust result vector accordingly, simple LOOKUP(), which is available for any version, works
=F5*LOOKUP(G5&"-"&D5,{"µA-A","µA-mA","A-µA","A-A","A-mA","mA-µA","mA-A","mA-mA","μm-μm"},{0.000001,0.001,0.000001,1,0.001,1000,0.001,1,1})
