I have a worksheet I want to compute mileage on. Right now we're doing
everything manually, but I want to see if I can automate the process in Excel
without resorting to a lot (if any) VB code.

The formula needs to examine 4 columns for the start point, then 43 or so
columns for the destination point. From there it can reference another sheet
with the mileage between two points and insert the correct value.

The logic looks something like this: "Look for data in array a and in array
b then depending on which columns hold the data, lookup the corresponding
result in worksheet x and enter the result in cell y"

Using the If, match and index functions I can get the result I want, but
only for 1 origination and 1 destination. Trying to extrapolate this out to
4*43 is causing a problem. Do I write a VBA function with all the necessary
formulas? Am I missing a function somewhere? I realize this may not be ideal
for Excel, but unfortunately that's what we are limited to using at this
point.

Right now the data entry person is keying in the load in each shipment, then
looking up her table to see where it started and where it ended and putting
in the mileage between points. So no real calculation is being done in the
worksheet in regards to miles, it's a manual lookup right now based on start
and end points.