Spreadsheet: 889721d1740630942-help-with-which-formula-to-use-to-get-the-right-code-for-an-expense-sample-worksheet-copy
Sheet: Sheet2

Company One code | Company 2 | Description of expense |  |  |  |  |  | KEY WORDS TABLE |  |  | priority order
20000 |  | uber to airport for orlando trip [NAME],n |  |  |  |  |  | uber | 60000 | Travel - Uber
20000 |  | uber return from event 8Aug24 smith,n |  |  |  |  |  | taxi | 60000 | Travel - meals
20000 |  | conference registration |  |  |  |  |  | ride | 60000 | Travel - meals
20000 |  | [NAME] at work conf smith, [NAME] |  |  |  |  |  | car service | 60000 | Travel - meals
20000 |  | 11Aug dinner wind conference | (dinner is higher priority than "conference" in keywords table |  |  |  |  | transport | 60000 | Travel - meals
20000 |  | 22Aug24 parking |  |  |  |  |  | airport transfer | 60000 | Travel - meals
 |  |  |  |  |  |  |  | pickup | 60000 | Travel - meals
 |  |  |  |  |  |  |  | dropoff | 60000 | Travel - meals
 |  |  |  |  |  |  |  | commute | 60000 | Travel - meals
 |  |  |  |  |  |  |  | shuttle | 60000 | Travel - meals
 |  |  |  |  |  |  |  | cab | 60000 | Travel - meals
 |  |  |  |  |  |  |  | lyft | 60000 | Travel - meals
 |  |  |  |  |  |  |  | travel to | 60000 | Travel - meals
 |  |  |  |  |  |  |  | travel from | 60000 | Travel - meals
 |  |  |  |  |  |  |  | trip to | 60000 | Travel - meals
 |  |  |  |  |  |  |  | trip from | 60000 | Travel - meals
 |  |  |  |  |  |  |  | return trip | 60000 | Travel - meals
 |  |  |  |  |  |  |  | one-way trip | 60000 | Travel - meals
 |  |  |  |  |  |  |  | ride share | 60000 | Travel - meals
 |  |  |  |  |  |  |  | ride hailing | 60000 | Travel - meals
 |  |  |  |  |  |  |  | lunch | 60001 | Travel - meals
 |  |  |  |  |  |  |  | dinner | 60001 | Travel - meals
 |  |  |  |  |  |  |  | breakfast | 60001 | Travel - meals
 |  |  |  |  |  |  |  | meal | 60001 | Travel - meals
 |  |  |  |  |  |  |  | food | 60001 | Travel - meals
 |  |  |  |  |  |  |  | restaurant | 60001 | Travel - meals
 |  |  |  |  |  |  |  | [NAME] | 60001 | Travel - meals
 |  |  |  |  |  |  |  | catering | 60001 | Travel - meals
 |  |  |  |  |  |  |  | dining | 60001 | Travel - meals
 |  |  |  |  |  |  |  | snack | 60001 | Travel - meals
 |  |  |  |  |  |  |  | refreshment | 60001 | Travel - meals
 |  |  |  |  |  |  |  | coffee | 60001 | Travel - meals
 |  |  |  |  |  |  |  | tea | 60001 | Travel - meals
 |  |  |  |  |  |  |  | beverage | 60001 | Travel - meals
 |  |  |  |  |  |  |  | banquet | 60001 | Travel - meals
 |  |  |  |  |  |  |  | buffet | 60001 | Travel - meals
 |  |  |  |  |  |  |  | takeout | 60001 | Travel - meals
 |  |  |  |  |  |  |  | delivery | 60001 | Travel - meals
 |  |  |  |  |  |  |  | fast food | 60001 | Travel - meals
 |  |  |  |  |  |  |  | reception | 60001 | Travel - meals
 |  |  |  |  |  |  |  | hospitality | 60001 | Travel - meals
 |  |  |  |  |  |  |  | culinary | 60001 | Travel - meals
 |  |  |  |  |  |  |  | eat | 60001 | Travel - meals
 |  |  |  |  |  |  |  | drink | 60001 | Travel - meals
 |  |  |  |  |  |  |  | refreshment break | 60001 | Travel - meals
 |  |  |  |  |  |  |  | working lunch | 60001 | Travel - meals
 |  |  |  |  |  |  |  | working dinner | 60001 | Travel - meals
 |  |  |  |  |  |  |  | parking | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | registration | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | fee | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | toll | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | baggage | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | luggage | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | tip | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | gratuity | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | laundry | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | cleaning | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | supplies | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | stationery | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | printing | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | postage | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | shipping | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | courier | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | miscellaneous | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | incidental | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | souvenir | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | gift | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | conference | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | event | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | workshop | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | seminar | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | training | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | meeting | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | expense | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | service charge | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | convenience fee | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | handling fee | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | admin fee | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | documentation | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | visa | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | passport | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | travel insurance | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | health check | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | vaccination | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | covid test | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | safety equipment | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | emergency | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | repair | 60002 | Travel - Incidential
 |  |  |  |  |  |  |  | maintenance | 60002 | Travel - Incidential