I'm trying to build an Excel formula which will use TWO lookup values to return a cell value in a range.
I've attached an example sheet of what I'm trying to do. It consists of a lookup table of 3 columns showing the distances in miles from a list of various UK towns to Birmingham and also to Manchester.
I want the user to select a town from the dropdown list in the 'From' cell, and to select a town from the dropdown list in the 'To' cell. On a correct match in the lookup table, the value returned should be displayed in the 'Mileage' cell.
It is assumed that either Birmingham or Manchester will be selected from at least one of the dropdown lists.
I've tried INDEX/MATCH but can't get the result I need.