Well, your ranges are OK, it could be that you are using the
alphabetic order in your reference table ...
and that you should replace lookup() by a combination of index() and
match()