If Certain Text contained in Cell F1, return value from Cell A1

[jeannerunning]

I have been spending way too long trying to figure this out. Hopefully you can help!

I Want to look at the data from Sheet 1, and if so, output the data to sheet 2. Specifically,

If Sheet 1 Column F1 contains the words 'Top 30,' then output the value from Sheet 1 Column A1 to Sheet 2 Column A1.

Example of values in F:

Q3 14: Opt Q3 14: Top 30

Q3 14: Top 30

Q3 14: Deals Q3 14: Top 30

<colgroup><col style="width: 250px"></colgroup><tbody>
</tbody>

AND ideally, i also want

If Sheet 1 Column F1 does NOT contain the words 'Top 30,' then filter out this row and do not input any value into Sheet 2.

SO, i would like this to look as follows...

Sheet 1: Column A1 = 1234, Sheet 1: Column F1= Q3 14: Opt Q3 14: Top 30, Sheet 2 Column A1 = 1234

What would be the formula i would use? and then i plan to drag this down.

 

[pdevito3]

From what I understand what you are saying, put the below in Sheet 2 A1

=IF(Sheet1!$F$1=TRIM("Top 30"),Sheet1!$A$1,"")

You might need to change the sheet names, but should be good otherwise. FYI, all the trim funciton is doing is making sure it still catches the string if there is an extraneous space ("Top 30 " v "Top 30")