All columns that are cited in a single LOOKUP attribute must belong to the same table. Check the spellings of the names, and make sure that they are the columns you intended.