Perhaps I missed something in your post, but are you asking why a lookup fails if there is no data in the lookup table?

By default, if a value is not found during a lookup operation (your data flow has ID "1" but it is not in the lookup table) a lookup component will fail. You can configure the error output of the lookup to ignore failures. If you do this, not finding the record will result in returning NULL.