Most valuable professional
  • Hot Topics

Excel Formula Lookup Multiple Distance

Hi All Actually I need a formula which lookup multiple distance from given below table when I select origin and destination it gives me result as per given below result table. Destination Touch Points Origin A B C D E Required Result through formula If i select origin and destination from below than formula gives result as mentioned in below result table Selection Example origin A Result By Formula

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of November 30, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel