Spreadsheet: 293308d1390942676-dependent-picklist-index-match-pivot-tables-or-best-option-multiple-sheets-multiple-lists
Sheet: TS&C Input Data

 |  |  |  |  |  |  |  |  |  |  |  | Services | Prices
PERMIT |  |  | No. OF [NAME] |  | QUANTITY |  | QUANTITY |  |  |  |  | Permit- Obtain | 105
Obtain | 105 |  | 0 |  | 0 |  | 0 |  | Bravo, [NAME] |  |  | Permit- Other | 0
Other | 0 |  |  |  |  |  |  |  | [NAME], [NAME]" |  |  | Trailer- Daily | 79.69
 |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | Trailer- Stanby / Other | 0
TRAILER |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | Trailer- MIRU / RDMO | 1000
Daily* |  |  |  |  |  |  |  |  | Cortez, [NAME] |  |  | Anchors- MIRU / RDMO | 265.63
Standby / Other | 0 |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | Anchors- $45.00 / Per (Select Total Cost)
MIRU | 1000 |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | [NAME] / Other | 0
RDMO | 1000 |  |  |  |  |  |  |  | Downing, [NAME] |  |  | Generator- Daily | 159.38
Standby / Other | 0 |  |  |  |  |  |  |  | Drewery, [NAME] |  |  | [NAME] / Other | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <- I just put words here so u knew what I was doing
 |  |  |  |  |  |  |  |  | Ducote, [NAME] |  |  | Generator- MIRU / RDMO | 595
ANCHORS |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | Septic System (500gal)- Per day | 47.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Picklist -> | Septic System (500gal)- Per day |  | <- here it is. The 0 is a way to pick less than greater than…. But 0 means exact match. I think u can even leave that out.
MIRU & RDMO |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | Septic System (500gal)- Standby / Other | 0
Standby / Other | 0 |  |  |  |  |  |  |  | Hall, Nolan |  |  | Septic System (500gal)- MIRU | 400
 |  |  |  |  |  |  |  |  | Jimenez, [NAME] |  |  | Sewer Tank- Per day | 37.19
GENERATOR |  |  |  |  |  |  |  |  | McCoy, Art |  |  | Sewer Tank- Standby / Other | 0
Daily |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | Sewer Tank- MIRU / RDMO | 400
Standby / Other | 0 |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | Water Tank (3,000gal)- Per day | 37.19
MIRU & RDMO | 595 |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | Water Tank (3,000gal)- Standby / Other | 0
Standby / Other | 0 |  |  |  |  |  |  |  | [NAME], [NAME]" |  |  | Water Tank (3,000gal)- MIRU / RDMO | 400
 |  |  |  |  |  |  |  |  | Scott, [NAME] |  |  | Water Jugs (5.0gal)- Deliver | 295
SEPTIC SYSTEM (500gal) |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | Water Jugs (5.0gal)- Other | 0
Per day |  |  |  |  |  |  |  |  | Tondreau, [NAME] |  |  | Water Jugs (5.0gal)- Per Jug | 20.77
Standby / Other | 0 |  |  |  |  |  |  |  | Urmy, [NAME] |  |  | Water Jugs (5.0gal)-Deposit | 7.44
MIRU | 400 |  |  |  |  |  |  |  | Williford, [NAME] |  |  | VSAT- Per day | 85
Other | 0 |  |  |  |  |  |  |  | Winslow, [NAME] |  |  | VSAT- Standby / Other | 0
 |  |  |  |  |  |  |  |  | [NAME], [NAME] |  |  | VSAT- MIRU | 85
SEWER TANK |  |  |  |  |  |  |  |  |  |  |  | [NAME] Increase- Per day | 40
Per day |  |  |  |  |  |  |  |  |  |  |  | [NAME] Increase- Standby / Other | 0
Standby / Other | 0 |  |  |  |  |  |  |  |  |  |  | Wireless Access Point- Per day | 15
MIRU & RDMO | 400 |  |  |  |  |  |  |  |  |  |  | Wireless Access Point- Standby / Other | 0
Other | 0 |  |  |  |  |  |  |  |  |  |  | Wireless Access Point- MIRU / RDMO | 75
 |  |  |  |  |  |  |  |  |  |  |  | HP OfficeJet Pro 8600- Per day | 15
WATER TANK (3,000gal) |  |  |  |  |  |  |  |  |  |  |  | HP OfficeJet Pro 8600- Standby / Other | 0
Per day |  |  |  |  |  |  |  |  |  |  |  | [NAME] Per day | 5
Standby / Other | 0 |  |  |  |  |  |  |  |  |  |  | [NAME] | 0
MIRU & RDMO | 400 |  |  |  |  |  |  |  |  |  |  | Cell Phone Ampliphier- Per day | 20
Other | 0 |  |  |  |  |  |  |  |  |  |  | Cell Phone Ampliphier- Standby / Other | 0
 |  |  |  |  |  |  |  |  |  |  |  | Cell Phone Ampliphier- MIRU / RDMO | 200
WATER JUGS (5.0gal) |  |  |  |  |  |  |  |  |  |  |  | Potable Water (3,000gal)- Per delivery | 540
Deliver | 295 |  |  |  |  |  |  |  |  |  |  | Potable Water (3,000gal)- Other | 0
Other | 0 |  |  |  |  |  |  |  |  |  |  | Trailer Cleaning Services- Per Cleaning | 377.5
Per Jug |  |  |  |  |  |  |  |  |  |  |  | Trailer Cleaning Services- Other | 0
Other | 0 |  |  |  |  |  |  |  |  |  |  | Sewer Tank Pump Out- Per Cleaning | 860.63
Deposit |  |  |  |  |  |  |  |  |  |  |  | Sewer Tank Pump Out- Other | 0
Other | 0 |  |  |  |  |  |  |  |  |  |  | Diesel- Per delivery | 540
 |  |  |  |  |  |  |  |  |  |  |  | Diesel- Other | 0
VSAT
Per day | 85
Standby / Other | 0
MIRU | 850
Other | 0
BANDWIDTH INCREASE
Per day | 40
Standby / Other | 0
WIRELESS ACCESS POINT
Per day | 15
Standby / Other | 0
MIRU & RDMO | 75
Other | 0
HP OFFICEJET PRO 8600
Per day | 15
Standby / Other | 0
PANASONIC DESK PHONE
Per day | 5
Standby / Other | 0
CELL PHONE AMPLIFIER
Per day | 20
Standby / Other | 0
MIRU & RDMO | 200
Other | 0
POTABLE WATER (3,000gal)
Per delivery | 540
Other | 0
TRAILER CLEANING SERVICE
Per Cleaning | 377.5
Other | 0
SEWER TANK PUMP OUT
Per Cleaning
Other | 0
DIESEL
Per delivery | 540
Other | 0
Other | 0