Creating a Search Concat for Sharepoint files

[NWE]

Hi,

I do not know if this is the right place, but I'll ask it anyway.

I want to use a concatenation of columns to search for files in Sharepoint through a hyperlink in it's own column.

For Example

=Hyperlink(Sharepoint.com, "A$, B$, C$").

I hope I explained that correctly..if I didn't please let me know.