Improving 'Select' Column Display for Better Data Lookup Clarity

When you lookup data in another table, if one of the fields is a 'Select' column, the value selected will never appear as text and rather the id that the selected value is assigned. It would be nice if it would grab the text value so that you don't have to setup complex and unnecessary formulas without making the column in the original table just a 'Text' field.