Spreadsheet: 856482d1705695855-if-then-vlookup-defined-names-test-travel
Sheet: DROP DOWN

 |  |  |  |  | SELECT ONE |  |  | SELECT ONE |  | SELECT ONE |  |  | If [NAME] is updated, Change the Year
AK - FT WAINWRIGHT |  | SELECT ONE |  | CONFERENCE - DOD SPONSORED | CONFERENCE - DOD SPONSORED |  |  | LODGING PLUS M$IE - NORMAL TDY |  | POC-AUTO - GOV is avail | 0.21 |  | 2024
AL - FT RUCKER |  | PLANE |  | CONFERENCE - NON-DOD SPONSORED | CONFERENCE - NON-DOD SPONSORED |  |  | ACT EXP FOR M&IE & LODG < 301% | (Approval Memo Required) | POC-AUTO - NO GOV avail | 0.67
AL - REDSTONE ARSENAL HUNTSVILLE (METRO AREA) |  | GOVT AUTO |  | DAU - DEFENCE ACQUISITIONS UNIV | DAU - DEFENCE ACQUISITIONS UNIV |  |  | ACT EXP [NAME] ONLY UP TO 300% | (Approval Memo Required) | POC-Motorcycle | 0.65
AZ - FT HUACHUCA |  | POV | Was POV advantagous to the Govt? | EEE - COVID 19 AUTHORIZATIONS | EEE - COVID 19 AUTHORIZATIONS |  |  | COE FLOATING PLANT |  | POC-Airplane | 1.76
AZ - YUMA PROVING GROUND |  | RENTAL CAR |  | EMEREGNECY | EMEREGNECY | If Known-Enter Operation Name |  | NO PER DIEM
CA - MARINE AIR/GROUND COMBAT CTR, 29 PALMS (METRO AREA) |  |  |  | ENTITLEMENT | ENTITLEMENT
FL - MACDILL AFB, TAMPA (METRO AREA) |  |  |  | EXPERT/CONSULTANTS | EXPERT/CONSULTANTS
GA - FT BENNING |  |  |  | FEMA - EMERGENCY | FEMA - EMERGENCY | If Known-Enter Operation Name
GA - FT GORDON |  |  |  | INFORMATION MEETING | INFORMATION MEETING
GA - FT STEWART |  | SELECT ONE |  | OTHER | OTHER | [NAME]
GA - HUNTER ARMY AIRFIELD |  | ALL |  | PRESENTATION/SPEECH | PRESENTATION/SPEECH
IL - ROCK ISLAND ARSENAL, QUAD CITY (METRO AREA) |  | PARTIAL AMOUNT | Enter Amt | RELOCATION | RELOCATION
KS - FT LEAVENWORTH |  |  |  | SITE VISIT/ | SITE-VISIT | LOCATION?
KS - FT RILEY |  |  |  | SPECIAL MISSION | SPECIAL MISSION
KY - FT KNOX |  |  |  | TRAINING ATTENDANCE | TRAINING-ATTENDANCE | Enter # of Hours
LA - FT POLK |  |  | SELECT ONE
MD - FT GEORGE G MEADE, FT MEADE (METRO AREA) |  |  | SUPPLEMENTAL
MO - FT LEONARD WOOD |  |  | PARTIAL
NC - FT BRAGG, FAYETTEVILLE (METRO AREA) |  |  | FINAL
NY - NAVAL SUPPORT ACT SARATOTOGA SPGS (METRO AREA) |  |  |  | SELECT MANAGER
NY - FT HAMILTON |  |  |  | Texoma_Lake_Manager |  | SELECT ONE
OH - WRIGHT-PATTERSON AFB, DAYTON (METRO AREA) |  |  | SELECT OFFICE | Waurika_Lake_Manager |  | NO | Skip to Itinerary
OK - FT SILL |  |  | PPMD | . |  | YES
PR - FT BUCHANAN |  |  | C&S
SC - JNT BASE CHARLESTON, CHARLESTON (METRO AREA) |  |  | E&C |  |  | SELECT
SC - FT JACKSON |  |  | TAM_TAD_OTH |  |  | NO | Limited to Cost of Airfare
SC - SHAW AFB, SUMTER (METRO AREA) |  |  |  |  |  | YES
TX - FT HOOD
TX - FT SAM HOUSTON
TX - FT BLISS
UT - DUGWAY PROVING GROUND
UT - HILL AFB |  |  |  |  |  | SELECT IF APPLICABLE
VA - LANGLEY AFB, HAMPTON (METRO AREA) |  | UPDATE IBA FEE HERE |  |  |  | CONFIRMATORY | REQD AFTER TRAVEL STRT DT
VA - NORFOLK AREA INSTALLATIONS |  | Enter IBA FEE | 7.5 |  |  | VARIATION AUTHORIZED | MULTIPLE TDY STOPS AUTHZD
VA - FT EUSTIS, NEWPORT NEWS (METRO AREA) |  |  |  |  |  | TRAVEL ADVANCE REQD | TRAVEL ADVANCE IS REQUESTED | REQD AMT?
VA - SUFFOLK (METRO AREA)
VA - YORKTOWN FACILITY, YORKTOWN/WILLIAMSBURG (METRO AREA)
VA - FT LEE/PETERSBURG (METRO AREA) |  | SELECT ONE
VA - FT BELVOIR |  | TRANSPORTATION TICKET | Ticket Fare | $ |  | STATUS
VA - JB MYER-HENDERSON HALL |  | IBA-FEE (Carlson/SATO Fee) |  | $ |  | APPROVED | P
WA - SEATTLE-TACOMA AIRPORT AREA |  | MILEAGE TO AIRPORT | Enter Miles to Airport |  |  | DISAPPROVED | O
WA - FT LEWIS |  | MILEAGE FROM AIRPORT | Enter miles From Airport | $
 |  | PARKING FEES (AIRPORT) | Amount | $
 |  | RENTAL CAR | Amount | $
 |  | RENTAL CAR  GAS | Amount | $ |  | IBA FEE | 21.07
 |  | VICINITY MILEAGE | Enter total Round Trip Miles
 |  | PARKING FEES (HOTEL) | Amount | $
 |  | PARKING FEES (OTHER) | Amount | $
 |  | TAXI | Amount | $
 |  | SUBWAY | Amount | $
 |  | TOLLS | Amount | $
 |  | OTHER | Enter Descrip in Remarks | $
 |  | COMM AIR BAGGAGE FEE | Amount