Match/Index Formula for Text Data

I want to return ALL rows that contain a certain TEXT from a single column. 

Example:

Sheet 1 contains data columns A to Z, in which data will be added over time. In Sheet 2, I want to return all rows that match a text string in Column T of Sheet 1. As new rows of data are added to Sheet 1, I want the formula to check for the specified text string in Column T and, if matched, copy that row (its entire content from all columns) in a new row in Sheet 2. I do not want any blank rows between data in Sheet 2. 

I have tried several variances of Index/Match formulas using wildcards to search the text string, but searching for text istead of numerical values seems to be causing issues. 

 

By: Matt

Leave a Reply

Your email address will not be published. Required fields are marked *