Spreadsheet: 491252d1480368014-requesting-some-help-with-regards-to-a-vlookup-formula-sample-sheet-2
Sheet: Sheet1

Date | Time | Location | Repair | A/B | GROUP | EMPLOYEE | HAZARD |  | Date Range | 2016-03-20 00:00:00 | 2016-03-22 00:00:00
2016-03-17 00:00:00 | 250 | 111 access st | road sign | a | A1 | JONES | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Use in COUNTIFS to filter
2016-03-17 00:00:00 | 1350 | 3941 adams ave | road sign | a | A1 | JONES | N |  |  | DateRange |  |  |  | Location | A/B | [NAME] | YV |  |  |  | from | to | Range and condition
2016-03-19 00:00:00 | 1440 | 218 freedom | road sign | a | A3 | GILROY | N |  | Number of: | [NAME] | [NAME] |  |  | ADAMS AVE |  |  | 4 |  |  | Date Range | 2016-03-17 00:00:00 | 2016-03-29 00:00:00 | $A$2:$A$500,">="&$V$4,$A$2:$A$500,"<="&$W$4
2016-03-20 00:00:00 | 1445 | 897 rock well | pavement | a | B1 | BENS | Y |  | B |  |  |  |  | ADAMS | A |  | 3 |  |  | Time Slot | 0 | 700 | $B$2:$B$500,">="&$V$5,$B$2:$B$500,"<="&$W$5
2016-03-21 00:00:00 | 1928 | 2240 steam st | pavement | a | C2 | DAVIDS | Y |  | A |  |  |  |  |  |  |  |  |  |  | Location | adams |  | $C$2:$C$500,"*"&$V$6&"*"
2016-03-22 00:00:00 | 120 | 5992 major st | pavement | b | B2 | [NAME] | Y |  |  |  |  |  |  |  |  |  |  |  |  | Exact location | 3941 adams ave |  | $C$2:$C$500,$V$7
2016-03-22 00:00:00 | 700 | 4876 arthur st west | road sign | b | A2 | NELSON | Y |  |  |  | Location |  |  | Location | Repair | [NAME] | YV |  |  | Repair | road sign |  | $D$2:$D$500,$V$8
2016-03-22 00:00:00 | 1850 | 2401 zebra | pavement | B | A2 | WAGER | N |  | Time Slots |  | Adams |  |  | ADAMS | ROAD SIGN |  | 2 |  |  | A/B | B |  | $[NAME]
2016-03-22 00:00:00 | 1400 | 111 access st | road sign | B | C1 | TOM | Y |  | From | To | [NAME] | YV |  |  |  |  |  |  |  | GROUP | A |  | $F$2:$F$500,$V$10&"*"
2016-03-23 00:00:00 | 900 | 3941 adams ave | pavement | A | [NAME] | BILLINGS | N |  | 0 | 700 |  | 2 |  |  |  |  |  |  |  | Exact Group | A2 |  | $[NAME]
2016-03-25 00:00:00 | 535 | 3946 adams ave | pavement | A | B1 | FRAN | Y |  | 701 | 1600 |  | 0 |  | GROUP: | Location: | TOTAL | MF | YV
2016-03-29 00:00:00 | 1900 | 1119 access st | road sign | a | B3 | DELL | Y |  | 1601 | 2400 |  | 2 |  | A |  | A |  | 3
2016-03-29 00:00:00 | 2200 | 2200 adams ave | road sign | B | B3 | SANS | Y |  |  |  |  |  |  | A |  | B |  | 2
 |  |  |  |  |  |  |  |  | Time Slots | without date range |  |  |  | GROUP: | Location: | A/B
 |  |  |  |  |  |  |  |  | From | To | [NAME] | YV |  | A | ADAMS |  |  | 1
 |  |  |  |  |  |  |  |  | 0 | 700 |  | 2 |  | A | ADAMS | A |  | 1
 |  |  |  |  |  |  |  |  | 701 | 1600 |  | 6 |  | A | ADAMS | B |  | 0
 |  |  |  |  |  |  |  |  | 1601 | 2400 |  | 4
 |  |  |  |  |  |  |  |  | Location | Repair | A/B | MF |  | Time Slots |  |  |  |  |  | SUMPRODUCT is not necessary
 |  |  |  |  |  |  |  |  | ACCESS ST | Road Sign | B |  |  | From | To | Location: | MF | YV
 |  |  |  |  |  |  |  |  | ACCESS ST | PAVEMENT | B |  |  | 0 | 700 | ADAMS |  | 1
 |  |  |  |  |  |  |  |  | ADAMS AVE | Road Sign | B |  |  | 701 | 1600 | ADAMS |  | 2
 |  |  |  |  |  |  |  |  | ADAMS AVE | PAVEMENT | B |  |  | 1601 | 2400 | ADAMS |  | 1
 |  |  |  |  |  |  |  |  | ACCESS ST | Road Sign | A
 |  |  |  |  |  |  |  |  | ACCESS ST | PAVEMENT | A
 |  |  |  |  |  |  |  |  | ADAMS AVE | Road Sign | A
 |  |  |  |  |  |  |  |  | ADAMS AVE | PAVEMENT | A