Connect the lookup table to the other table and then use the field from the lookup table in the report.