What formula do I require for two criteria to match in order to give result?

**samuelleach** · 02-05-2015, 12:12 PM

I am creating a 'Mileage Calculator' in order to deduce the reimbursable miles employees drive per week. I am using Excel and have a database of all the possible 'A-B' combinations of our local postcodes (UK), and the distance in miles between each once, for example: | PL34 0ES | PL34 0AT | 0.7 |. The user, on a different sheet, selects a starting postcode and a finishing postcode for each of the journeys from a drop down list. What formula would I use to display the distance from the database as a result of the two input postcodes? Any help MUCH appreciated. Been trying to sort this all week

**bebo021999** · 02-05-2015, 12:18 PM

With:
A1:A10 is starting range
B1:B10 is finishing range
C1:C10 is distance range
D1 is dropdown of starting
D2 is dropdown of finishing

Try:

=LOOKUP(2,1/((A1:A10=D1)*(B1:B10=D2)),C1:C10)

**MarvinP** · 02-05-2015, 12:30 PM

Hi Samuel,

The answer depends on what your database looks like. I prefer to do these problems using a HELPER column where I join the start and end place names into a single cell. Then I like to use the VLookup function to get a distance. See the attached for the way I approach these problems.