Hi

I am working on a spreadsheet for dispatching round trips for delivery. I
know how long each trip should take based upon day of the week and
destination and I would like to have those values returned in a cell based
upon the day of the week and destination in two other cells.

I want to return a estimated number of minutes for a round trip based upon
the day of the week and the destination to a cell. I have approximately 75
destinations and of course, 7 days of the week.

Ex: If the day of the week (represented as the number 5) in A1 is Thursday
and the destination in B1 is Tool World, then the number of minutes I want in
C1 to show is 40 minutes.

If the day of the week (represented as the number 6) in A2 is Friday and the
destination in B2 is Tire Land, then the number of minutes I want in C2 to
show is 30 minutes.

And so on. I then plan on adding the number of estimated minutes to the
inserted time in another cell with a formula to give an estimated time of
return.

I am trying to figure out a formula that will accomplish this, but
unfortunately, am in over my head.

Much thanks and appreciation to any that can help

Randy