Fill Cell Contents On Multiple Conditions (Formula or VBA)

I'm working on a travel requirements spreadsheet. I'm quitting my job soon and it will probably be several years before they can find someone qualified to fill my job. My tasks will be divvied up among several people and I'm trying to develop a series of tools (Excel and otherwise) that will allow them to get by in the interim.

One of these items is a travel requirements worksheet. Essentially it's a table of people with relevant information. I have a number of calculations already to calculate various cost estimates. What I need now is essentially to fill the contents of one cell to specify which reimbursement form to complete based off city of residence AND distance. I thought I had a good idea of how to proceed with formulas, but the longer I tried to do the formula the more confused I've gotten.

"Table2" contains the data we're working with (this table may expand or shrink depending on personnel assignments). Multiple columns, but the only columns I'm focused on for this are:
'N' - Where I need the data to fill to (text specific based on other columns); [Header:VOUCHER_VER]
'J' - The city they live in; [Header:ADDRESS_CITY]
'M' - The distance (miles) from their home to permanent work site ("SAN ANTONIO"). [Header:DISTANCE_WS]

What I'm trying to do is get the following result for each individual (which will update if they change address info):

* If greater than or equal to 50 miles ('M'), regardless of city ('J'), then fill, "Zone 2 (Complete Voucher)" in 'N'.
* If less than 50 miles ('M') AND city ('J') is "SAN ANTONIO", then fill, "Zone 1A (Local, No voucher)" in 'N'.
* If less than 50 miles ('M') AND city ('J') is NOT "SAN ANTONIO", then fill, "Zone 1B (Mileage Only, No Voucher)" in 'N'.

Does that make sense? I do not care if it is a formula or requires VBA (I need to expand my horizons, anyway, and VBA might help reduce the chance of them overwriting a formula typed directly in the cell). I also intend to apply conditional (fill) formatting to each row based on which of the three options are filled in 'N' to help them better identify a person's status at-a-glance.

I'm certain this is possible. I'm just apparantly not quite up to the task all by myself.