I need to look up and populate sheet one with matching criteria on sheet 2. I
need two separate formulas to do the following:
Formula 1:
If  Column B on “Data” Sheet is Greater than Cell C3 on Summary Sheet AND
Column C on “Data” Sheet indicates “TRUE”, I need the “Name” (from column A)
and “Percent” (from column B) on “Data” Sheet to populate in the “Name”
(column B) and “Percent” (column C) on the “summary Sheet”. For example,
according to the data below, only Jen, Rob, Tony, John, and Jules, along with
their corresponding percentage will show up in columns B and C on the
“Summary” Sheet.

Formula 2:
If Column F on the “Data” sheet is equal to or greater than 1000, AND
Column “G” on the “Data” Sheet is less than Cell F3 on the “Summary” Sheet, I
need the I need the “Name” (from column A) and “Percent” (from column F) on
“Data” Sheet to populate in the “Name” (column E) and “Percent” (column F) on
the “Summary” Sheet. For example, according to the data below only Tony,
John, and Jules along with their corresponding percentage will show up in
columns E and F on the “Summary” Sheet.

As always, thank you to everyone in advance for your help!

Sheet 1 (Called “Summary”)

    B    C    D    E    F
2    Name    Percent        Name    Percent
3        1.87            115.47
4
5
6
7
8
9

Sheet 2 (Called “Data”)

    A    B    C    D    E    F    G
6    Name    Percent                Total      Percent
7    Jen    2.15    True            2646    117.6
8    Rob    1.99    True            172    142.2
9    Tony    2.52    True            3984    109.9
10    Roe    0.99    False            3599       118.98
11    John    1.94    True            4325       108.13
12    Phil    0.49    False            470         104.44
13    Kurt    1.25    False            931         103.44
14    Vic    4.31    False            0    0
16    Jules    5.45    True            1190    91.54