Not only is it possible, there are two basic approaches. One method copies data from a record in the lookup table to matching fields in the table from where you are doing the lookup. The other method simply uses a relationship to display data in fields from the related table.
Both methods have their uses. This thread describes both approaches and why you might use one method or the other: Auto Fill