Spreadsheet: 856981d1706105743-lookup-and-sort-from-other-worksheet-inventory-test
Sheet: Tools Jan 2024

 |  |  |  |  | ON DECK |  |  | S
 |  |  |  |  | ON LOCATION |  |  | O
 |  |  |  |  | ACTIVE |  |  | A
TOOL INVENTORY | Last Updated | 2024-01-24 00:00:00 |  |  | BACKLOADED |  |  | B
 | Updated By |  |  |  | USED |  |  | U
2024-01-01 00:00:00 | Client |  |  |  | STORED ON BOAT |  |  | W
 |  |  |  |  | STORED ONSHORE |  |  | X
 |  |  |  |  | READY FOR BACKLOAD |  |  | R
[NAME] | SERIAL NUMBER | ARRIVAL ON LOCATION | Basket S/N | BACKLOAD DATE |  |  |  |  |  | COMMENTS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Tool Set 1 | A123 | 2023-12-23 00:00:00 | 804645-0 | 2024-01-10 00:00:00 |  |  |  |  |  |  | A | A | A | A | A | A | S | S | S | B
Tool Set 2-A | B123 | 2023-12-23 00:00:00 | 803813-9 | 2024-01-07 00:00:00 |  |  |  |  |  |  | A | A | A | A | A | A | B
Tool Set 2-B | B124 | 2023-12-23 00:00:00 | 803813-9 | 2024-01-07 00:00:00 |  |  |  |  |  |  | O | O | O | O | O | O | B
Tool Set 2-C | B125 | 2023-12-23 00:00:00 | 803813-9 | 2024-01-07 00:00:00 |  |  |  |  |  |  | O | O | O | O | O | O | B
Tool Set 2-D | B126 | 2023-12-23 00:00:00 | 803813-9 | 2024-01-07 00:00:00 |  |  |  |  |  |  | O | O | O | O | O | O | B
Broom | B1 | 2024-01-08 00:00:00 | DNV39X40029 |  |  |  |  |  |  |  |  |  |  |  |  | W | W | O | O | O | A | A | A | A | A | A | A | U | U | U | U | U | U | U
Scoop | S1 | 2024-01-08 00:00:00 | DNV39X40029 |  |  |  |  |  |  |  |  |  |  |  |  | W | W | O | O | O | A | A | A | A | A | A | A | U | U | U | U | U | U | U
Broom | B2 | 2024-01-11 00:00:00 | DNV39X40010 |  |  |  |  |  |  |  |  |  |  |  |  | W | W | W | W | W | O | O | O | O | O | O | A | A | A | U | U | U | U | U
Scoop | S2 | 2024-01-11 00:00:00 | DNV39X40010 |  |  |  |  |  |  |  |  |  |  |  |  | W | W | W | W | W | O | O | O | O | O | O | A | A | A | U | U | U | U | U
Shovel | SL1 | 2024-01-20 00:00:00 | 803 799 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | O | O | A | A
Fork | F123 | 2023-12-23 00:00:00 | DNV39X40084 | 2024-01-06 00:00:00 |  |  |  |  |  |  | O | O | O | O | O | B
Fork | F124 | 2023-12-23 00:00:00 | DNV39X40084 | 2024-01-06 00:00:00 |  |  |  |  |  |  | O | O | O | O | O | B
Axe | AX01 | 2023-12-23 00:00:00 | DNV39X40075 | 2024-01-10 00:00:00 |  |  |  |  |  |  | O | O | O | O | O | O | O | O | O | B
Axe | AX02 | 2023-12-23 00:00:00 | DNV39X40075 | 2024-01-10 00:00:00 |  |  |  |  |  |  | O | O | O | O | O | O | O | O | O | B
 |  | 2023-12-23 00:00:00 | [NAME] | 2024-01-11 00:00:00 |  |  |  |  |  |  | A | A | A | A | A | A | S | S | S | U | B
 |  | 2023-12-23 00:00:00 | [NAME] | 2024-01-11 00:00:00 |  |  |  |  |  |  | A | A | A | A | A | A | S | S | S | U | B
 |  | 2024-01-08 00:00:00 | DNV39X40029 |  |  |  |  |  |  |  |  |  |  |  |  | W | W | O | O | O | O | O | O | O | O | O | A | A | A | U | U | U | A | A
 |  | 2024-01-11 00:00:00 | DNV39X40010 |  |  |  |  |  |  |  |  |  |  |  |  | W | W | W | W | W | O | O | O | O | O | O | A | A | A | U | U | U | U | U
 |  | 2023-11-11 00:00:00 | [NAME] | 2024-01-11 00:00:00 |  |  |  |  |  |  | O | O | O | O | O | O | O | O | O | O | B
 |  | 2023-11-11 00:00:00 | [NAME] | 2024-01-11 00:00:00 |  |  |  |  |  |  | A | A | A | A | A | A | U | U | U | U | B
 |  | 2023-12-03 00:00:00 | 803813-9 | 2024-01-07 00:00:00 |  |  |  |  |  |  | O | O | O | O | O | O | B
 |  | 2024-01-08 00:00:00 | DNV39X40082 |  |  |  |  |  |  |  |  |  |  |  |  | W | W | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O
 |  | 2024-01-08 00:00:00 | DNV39X40029 |  |  |  |  |  |  |  |  |  |  |  |  | W | W | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O
 |  | 2024-01-08 00:00:00 | DNV39X40002 |  |  |  |  |  |  |  |  |  |  |  |  | W | W | O | O | O | A | A | A | A | A | A | A | A | A | U | U | U | A | A