WHAT FUNCTION CAN I USE TO GET A NUMBER FROM ONE WORKSHEET TO ANO.

[Guest]

I have an excel worksheet that is called Mileage Chart. It lists hundreds of
origin cities and their corresponding state abbreviation. It also lists
destination cities and their states. All in separate cells. The next cell
contains the number of miles between those two cities. I have another
worksheet called driver payroll. I enter the origin and destination
city/state and I want excel to go find the mileage and automatically inserted
in the column labelled "miles driven". Can someone tell me if this can be
done?

 

[icestationzbra]

nelson,

what you are looking for can be very simply done using the workshee
function VLOOKUP. click on the 'fx' in the formula bar, in the box fo
'search for a function', enter VLOOKUP and click go. it is pretty muc
self explanatory.

if you need more info, post back with details on column and workshee
names, probably someone could write a tentative formula for you.

mac