Spreadsheet: 122712d1317086976-is-vlookup-the-right-function-lookup-two-values
Sheet: T-9

 |  | # OF CR1 TASKS = |  |  | 0 |  | [NAME] = |  | [NAME] "PLAN" "RET""SUSP" = |  |  | 0 |  |  |  |  |  |  | CR1 TOTAL HOURS = |  |  | 0
 |  | # OF CR2 TASKS = |  |  | 0 |  | CR2 WEEK RESOURCE LOADING = |  | CR2 TASKS "PLAN" "RET""SUSP" = |  |  | 0 |  |  |  |  |  |  | CR2 TOTAL HOURS = |  |  | 0
 |  | T- |  |  |  |  |  | 9 | WRK WEEK | 1 |  |  |  |  |  |  |  | 2011-09-26 21:28:36
ASSIGNED  WORKERS |  | WO # | TASK # | UNIT # | USI # | EQUIP # | WORK ORDER DESC | HOLDS | STATUS | TARGET START | HOURS | PRIORITY | WO TYPE | INTERRUPT | CRIT CAT | GRADE | UCR | EARLY DATE | LATE  DATE | CREW | EXCEPTION | NOTES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | T-9
2011-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-03 00:00:00 | 2011-01-04 00:00:00
 |  |  |  |  |  |  |  |  | CR1 MON TOTAL HOURS = |  |  | 0 |  |  |  |  | CR2 MON T0TAL HOURS = |  |  | 0
 |  |  |  |  |  |  |  |  | CR1 MON RESOURCE % = |  |  |  |  |  |  |  | CR2  MON  RESOURCE % =
 |  | 000113 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000114 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000115 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000116 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000117 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000118 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000119 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000120 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000121 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000122 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000123 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000124 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000125 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000127 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000128 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | 000129 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2011-01-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-04 00:00:00 | 2011-01-05 00:00:00
 |  |  |  |  |  |  |  |  | [NAME] TOTAL HOURS = |  |  | 0 |  |  |  |  | [NAME] T0TAL HOURS = |  |  | 0
 |  |  |  |  |  |  |  |  | [NAME] % = |  |  |  |  |  |  |  | [NAME] RESOURCE % =
 |  | 000126 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test comment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2011-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-05 00:00:00 | 2011-01-06 00:00:00
 |  |  |  |  |  |  |  |  | [NAME] TOTAL HOURS = |  |  | 0 |  |  |  |  | CR2 WED T0TAL HOURS = |  |  | 0
 |  |  |  |  |  |  |  |  | [NAME] % = |  |  |  |  |  |  |  | CR2 WED RESOURCE % =
 |  | 000111 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | test comments
 |  | 000112 | 01 |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remove and Reschedule
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2011-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-06 00:00:00 | 2011-01-07 00:00:00
 |  |  |  |  |  |  |  |  | CR1 THUR TOTAL HOURS = |  |  | 0 |  |  |  |  | CR2 THUR T0TAL HOURS = |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  | [NAME] = |  |  |  |  |  |  |  | CR2 THUR RESOURCE % = |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2011-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-07 00:00:00 | 2011-01-08 00:00:00
 |  |  |  |  |  |  |  |  | CR1 FRI TOTAL HOURS = |  |  | 0 |  |  |  |  | CR2 FRIT0TAL HOURS = |  |  | 0
 |  |  |  |  |  |  |  |  | CR1 FRI RESOURCE % = |  |  |  |  |  |  |  | CR2 FRI RESOURCE % =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2011-01-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-08 00:00:00 | 2011-01-09 00:00:00
 |  |  |  |  |  |  |  |  | CR1 SAT TOTAL HOURS = |  |  | 0 |  |  |  |  | CR2 SAT T0TAL HOURS = |  |  | 0
 |  |  |  |  |  |  |  |  | CR1 SAT RESOURCE % = |  |  |  |  |  |  |  | CR2 SAT RESOURCE % =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2011-01-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-09 00:00:00 | 2011-01-10 00:00:00
 |  |  |  |  |  |  |  |  | [NAME] TOTAL HOURS = |  |  | 0 |  |  |  |  | CR2 SUN T0TAL HOURS = |  |  | 0
 |  |  |  |  |  |  |  |  | [NAME] RESOURCE % = |  |  |  |  |  |  |  | CR2 SUN RESOURCE % =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WORK WEEK = |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] AND DAILY RESOURCE LOADING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK | MON | TUES | WED | THURS | FRI | SAT | SUN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVAILABLE HOURS |  | CR1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CR2 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCHEDULED HOURS |  | CR1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CR2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK | MON | TUES | WED | THURS | FRI | SAT | SUN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RES LOAD % |  | CR1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CR2