Search an Entire Sheet for Specific Text and Return the Column it is Located in

Hi all,

Is there a way to write a function that searches an entire other sheet in the spreadsheet for a specific line of text and return what column it is located in?

Or even better return the header of the column (which is in rows 1 and 2 that are combined).

Thanks!