Concatenate in lookup column

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?

0 2 95
2 REPLIES 2

Expression Example, 

Select(
Serial List[Serial #],
AND(
[Company Name] = [Serial #1].[Company Name],
[Column2] = [Serial #1].[Column2],
[Column3] = [Serial #1].[Column3]
)
)

That seems close, basically I want it to display multiple columns in the lookup.Screenshot 2023-08-17 3.42.01 PM.png

Top Labels in this Space