Hello! Was reading the tread and was hoping for some help. I am looking for something a lot this except when it finds the result no matter what column it is in I need the entire row to be displayed. Also If it could display the column headers too that would be cool if possible. The column headers are different on each spreadsheet.

Thanks in advance.