Two criteria to match to obtain result from database?

Hello all, I have recently posted a query

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

I suppose I did not word it as best a possible, so I have attached my spreadsheet. Places are selected on sheet1 (mileage calculator) and it displays the postcodes in the boxes nextdoor. J9:J46 Would display distances as a result of the information in sheet2 (database), though I can't for the life of me figure out how to do it. Please please someone help a newb in distress

Mileage calculatorsam (1).xlsx

PS: Accidently deleted formula from a few top boxes of of the postcode box on Sheet1, just drag up from a lower undeleted cell.

As mentioned in your previous thread, LOOKUP can do the trick

J9:

Please Login or Register  to view this content.

Use this structure:

=IFERROR("Formula here","")

means If Formula error, returns blank, else returns result.

Try this

=IFERROR(LOOKUP(2,1/((Database!$M$6:$M$1449=Mileage_Calculator!G9)*(Database!$N$6:$N$1449=Mileage_Calculator!I9)),Database!$O$6:$O$1449),"")

You are welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.