Problems with formulas in Excel 2013

[fish_dan]

Hello,

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

Sheet 1 Times; would be the locations I would receive on my day to day work:
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.

 

[fish_dan]

Hi Death,

Thank you very much for the help! This is defiantly pointing me in the right direction.
So I have made a mock up SS and entered the following:

=Index(Sheet2!$A$2:$C$2,Match(1,Sheet2!$A$2:$A$7=Sheet1!A2)*(Sheet2!$B$2:$B$7=Sheet1!B2),0),3)



The error highlights ",3)" when I press Ctrl Shift and enter on the formula.

Any ideas?

 

[fish_dan]

[*]Populate that column so that it reads something like "Location X to Location Y" e.g. =B2 & " to " & C2.
[/LIST]

As in re-name the columns B2 & the & C2?

then the VLOOKUP will pull from these?

 

[fish_dan]

Yup, you need a left bracket after match(1,

When i add the bracket the whole formula lights up indicating an error...