I am having some trouble trying to make my spreadsheet formulas work in an excel spreadsheet on dispatch times.

The idea was; i would have two sheets (Times (sheet1) & Data (sheet2))

Sheet 2 Data; would have lots of various destinations:

- Column A - Location 1
- Column B - Location 2
- Column C - Time taken from Loc 1 to 2

E.G. a driver is going from Crawley to York.

So what I am trying to do is use a combination of VLOOKUPS and MATCH formulas; so when I input the locations into sheet 1, the formula will look up the data from sheet 2, find that location 1 & 2 match from sheet 2s data and then show the time taken data from sheet 2 into sheet 1 in column C

I am no expert at excel, but have been trying this for a while with little success.

Any help is very much appreciated.

Any further questions, please ask.

P.S. I am unable to upload the spreadsheet because I do not know how.