Hello, have 2 sheets. On sheet B I have values listed in column K. On sheet A I need to enter a formula to lookup the values in column K on Sheet B and if there are any values in K greater than 100, list that data on sheet A. Tried a VLOOKUP but could get it to work.
<tbody>
</tbody><colgroup><col><col span="4"><col><col><col><col><col><col></colgroup>
SHEET A | ||||||||||
A | B | C | D | E | F | G | H | I | J | K |
SC | 6/2/2014 13:45 | 6/2/2014 21:08 | 6/3/2014 17:28 | 6/4/2014 17:21 | JTRELA | 6/5/2014 9:26 | MSCSSC2 | 6/5/2014 19:30 | DCOWAN | 1250 |
SC | 6/2/2014 11:20 | 6/2/2014 12:42 | 6/2/2014 15:10 | 6/2/2014 15:55 | MHARRIS | 6/2/2014 17:43 | BHUMPHRE | 6/3/2014 15:40 | TEJONES | 252 |
SC | 6/2/2014 10:37 | 6/2/2014 11:39 | 6/3/2014 18:30 | 6/3/2014 19:04 | PORTIZ | 6/4/2014 14:09 | CHART | 6/4/2014 16:19 | AGUILLEB | 1100 |
SC | 6/2/2014 13:45 | 6/2/2014 19:57 | 6/3/2014 12:45 | 6/3/2014 13:03 | JTRELA | 6/3/2014 16:52 | SDAWSON | 6/4/2014 20:09 | DCOWAN | 110 |
SHEET B | ||||||||||
A | B | C | D | E | F | G | H | I | J | K |
SC | 6/2/2014 12:29 | 6/2/2014 17:28 | 6/2/2014 18:02 | 6/3/2014 14:19 | JTRELA | 6/3/2014 15:53 | SDAWSON | 6/5/2014 9:00 | AGUILLEB | 98 |
SC | 6/2/2014 11:20 | 6/2/2014 20:10 | 6/3/2014 8:46 | 6/3/2014 15:25 | JTRELA | 6/4/2014 15:58 | SDAWSON | 6/5/2014 15:15 | AGUILLEB | 70 |
SC | 6/2/2014 11:20 | 6/2/2014 13:02 | 6/2/2014 18:48 | 6/3/2014 9:20 | JTRELA | 6/3/2014 9:29 | JTRELA | 6/3/2014 12:35 | DPEPPERS | 55 |
SC | 6/2/2014 13:45 | 6/2/2014 21:08 | 6/3/2014 17:28 | 6/4/2014 17:21 | JTRELA | 6/5/2014 9:26 | MSCSSC2 | 6/5/2014 19:30 | DCOWAN | 1250 |
SC | 6/2/2014 11:20 | 6/2/2014 12:42 | 6/2/2014 15:10 | 6/2/2014 15:55 | MHARRIS | 6/2/2014 17:43 | BHUMPHRE | 6/3/2014 15:40 | TEJONES | 252 |
SC | 6/2/2014 13:45 | 6/2/2014 19:57 | 6/3/2014 12:06 | 6/3/2014 14:07 | JTRELA | 6/3/2014 15:55 | SDAWSON | 6/5/2014 9:09 | CMACOMSO | 75 |
SC | 6/2/2014 10:37 | 6/2/2014 11:39 | 6/3/2014 18:30 | 6/3/2014 19:04 | PORTIZ | 6/4/2014 14:09 | CHART | 6/4/2014 16:19 | AGUILLEB | 1100 |
SC | 6/2/2014 11:20 | 6/2/2014 13:02 | 6/3/2014 14:53 | 6/3/2014 16:03 | ACLINKSC | 6/3/2014 16:09 | BHUMPHRE | 6/5/2014 10:58 | LHAMMOND | 11 |
SC | 6/2/2014 13:45 | 6/2/2014 19:57 | 6/3/2014 12:45 | 6/3/2014 13:03 | JTRELA | 6/3/2014 16:52 | SDAWSON | 6/4/2014 20:09 | DCOWAN | 110 |
<tbody>
</tbody><colgroup><col><col span="4"><col><col><col><col><col><col></colgroup>