OfficeFrustration - View Single Post

**Ron Rosenfeld**

On Thu, 27 Dec 2007 11:13:08 -0800, Randy Weitzel Randy
wrote:

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

Set up a data table:
1 2 3 4 5 6 7
Tool World 29 23 17 12 21 30 39
Tire World 22 25 18 10 24 38 52
Tire Land 13 21 25 14 16 18 20

Note days of the week in the first row; and destinations in first column.

Name the table: Tbl.

Use this formula:

=VLOOKUP(B1,Tbl,A1+1,0)

--ron