Excel 2013 Formula Help

[fish_dan]

Hi Everyone,

I'm having trouble with getting a formula to work on Excel 2013.
I have a list or raw data on Sheet2 it contains 3 columns:

• Location 1
• Location 2
• Time taken

What I am trying to achieve is; in Sheet1, when I enter in two of the locations that match from Locations 1&2 (in Sheet2), the 'Time taken' figure will be displayed (in Sheet1).

I have messed around with INDEX/MATCH & VLOOKUP but nothing is working... I must be going about it the wrong way?

Any ideas?

Thanks

Dan

 

[fish_dan]

can you host it somewhere so I can download it and play around with it?

i'm guessing it's going to be nested IF statements

Hi Harvey,

Any idea how I would go about sharing/hosting this?
I could email you the document?

 

[fish_dan]

Bump.

 

[fish_dan]

Do you know how i can put my SS on here so you can see what i mean?

 

[fish_dan]

Put it on some cloud storage that allows you to publish a public link and put the URL in this post. Dropbox will do it for example

OK I have put it onto Dropbox, how do i link it on here?

 

[fish_dan]

Please could you PM me your email address so I can add you to my Dropbox sharefolder, so you can see the document?

 

[fish_dan]

So after more playing with this formula i know that i will need VLookup 100%:

=IFERROR(VLOOKUP(""&A82,Location!A:C,2,FALSE)," ")

But i also need Match in there somewhere to make it work... However when i add it; i always get #DIV error

Any ideas anyone?