I'd hazard a guess that the values in your lookup vector: Units!$F$36:$F$41
are not exactly placed in ascending order ..
So you might have been lucky in getting it to work correctly for some lookup
values, but not for others, as was inferred in your original post. Did the
suggested alternative work for you ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"greencecil" wrote in message
...
Thanks for the suggestion, but I still don't understand why my formula
works
for all the other units (text list searched) I try, but not for those
beginning with 'kg/'. If the formula was wrong, it wouldn't work at all
would
it?