Well, if you have checked your ranges and they are OK ...
it could be that there is no alphabetic order in your reference
table ...

If it is the case, you should replace lookup() by a combination of
index() and
match() ...

HTH