Look up using multiple sheets and multiple criteria
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
|