multiple columns in select column

[EricBWS]

Is it possible to get multiple columns to CONCATENATE into a column that is a ref with a select formula for values?

My current suggested values formula is Select(Serial List[Serial #], [Company Name]=[Serial #1].[Company Name]).

Could I anyway get multiple columns on that suggested formula list? For example, my serial list has columns for NEW/OLD, YEAR, MONTH.  Could I make it say when you click the drop down.

Example - Serial Test # New 2023 January