If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NCoppersmith" wrote in message
...
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.