Return a Text Value based on criteria

I'm trying to create a formula that will allow me to pull test from a list (auto populate if possible).

Essentially you will see on the second tab, a list of projects "Cali" for example. I'm trying to find a formula that will allow me to show the Customer and Life Cycle on the first Tab. If possible the Project Name too. Essentially I want to be able to have all the data inputed into Tab 2 and let Tab 1 condense it into the designated fields. So basically what will allow me to see all of the "Cali" projects, and from that generate the Customer and Life Cycle (and Project if possible) on Tab 1.

Keep in mind this does need to be automatic updating, so that as we input more information on Tab 2, it will automatically kick into Tab 1.

Any thoughts?

Spreadsheet attached for reference.

Hi Sean, you might try this formula in A3 on the Forecast sheet (and copy down/right to B6):

=INDEX(Data!A:A,MATCH(Forecast!$C3,Data!$C:$C,0))

This assumes you won't have more than one Customer or LifeCycle per Project.