In one spreadsheet, I have a list of origin cities in column A and a list of destination cities in column B. In column C, I have the mileage between the two.
In another spreadsheet, I have the same list of origin and destination cities but with the rate per mile for each route in column C. This spreadsheet is not in the same order as the first one.
What formulae can I use to bring over the content of spreadsheet 2, column C, and have it in correctly ordered with the content of spreadsheet 1? I am planning on multiplying the rate per mile by the mileage to get the rate for the trip so the mileage and the rates must match.