If row 1 contains <text> add column value A1 (<name>) to separate sheet

[imikeyr]

Greetings all!

I have an exported CSV file from a ticket system, but all tickets ordered by participants are sitting a row with columns of ticket/show names.
We need to sort all the names out for the right ticket lists.

What formula I need:
If row 1 contains <"text"> add column value A1 (<name>) to separate sheet.

In the example on attached image it would be:
If row 1 contains "Tine Salling - Entre Nous" then add column value A1 ("Tessa Geraldino") to separate sheet (or i.e. A13.)

DOWNLOAD AND WORK ON EXAMPLE FILE HERE:
https://www.dropbox.com/s/9q8klhdrgd...mary.xlsx?dl=0


Screen Shot 2014-10-28 at 13.15.33.png

[Naveed Raza]

Please attached sample workbook it will make easy to understand your query and to solve

[imikeyr]

Thanks for the tip!

Added link to Excel-file above now!

(And here: https://www.dropbox.com/s/9q8klhdrgd...mary.xlsx?dl=0)

[imikeyr]

*bumpin' it*

[Naveed Raza]

Need some clarification

1) For this "Panta Rei Danseteater - Behind The Mirror" what are the names you want ?
2) "Panta Rei Danseteater - Behind The Mirror" - Should i supposed to check only in Column F ?

[imikeyr]

If "Panta Rei..." is present in the row, then add name from column "First Name" to the list on the main sheet.

(The data is based on a form that people have filled out with their info, and checked off in boxes what shows they wanna see. We want to auto-sort the names in shows-lists.)