Basic lookup again

[James Tebb]

Explaining Further On A Previous Problem.
Sheet 1 has the following table
COLUMN A - Start Point (eg Liverpool)
COLUMN B - End Point (eg Manchester)
COLUMN C - Miles (eg 60)

Sheet 2 Allows User To Input Their Journey
Cell A1 - Start Point (eg Liverpool)
Cell B1 - End Point (eg Manchester)

I want Cell C1 to return the distance.

eg find the start point that matches, find the end point that matches and return the value in column C.

Any Ideas

 

[Andrew Poulsom]

Try eg:

=INDEX(Sheet1!C1:C1000,MATCH(1,INDEX((Sheet1!A1:A1000=A1)*(Sheet1!B1:B1000=B1),),FALSE))