Using a lookup table for a calculated column AND a relationship at the same time -- is it possible?

I have a dataset (main table) with a numeric value that's binned based on another table created via manual table entry. The bin table has a category name field, which is the field used to relate t...