title: Lookup values from table
body: <p>Please I want to write a formula to get the Distance (4th column) between From and To Cities  (2nd and 3rd columns) for a particular Order ID (1st column) in Table 1 while looking up data from the Distances worksheet as shown below.</p>
  <p><a href="https://i.stack.imgur.com/3stIY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3stIY.png" alt="Table 1" /></a></p>
  <p>Distances worksheet:
  <a href="https://i.stack.imgur.com/jvqQ9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jvqQ9.png" alt="Distances worksheet" /></a></p>