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

[Sirfyaad]

@EricBWS

Select(
Serial List[Serial #],
AND(
[Company Name] = [Serial #1].[Company Name],
[NEW/OLD] = [Serial #1].[NEW/OLD],
[YEAR] = [Serial #1].[YEAR],
[MONTH] = [Serial #1].[MONTH]
)
)

[NathanSADE]

THANK YOU