title: Using index and match with multiple conditions in Excel
body: <p>I have the following race car telemetry data in an Excel worksheet: <a href="https://i.stack.imgur.com/FfBhM.png" rel="nofollow noreferrer">Telemetry data</a></p>
  <p>In another sheet, I have a table which defines the start and end distances of each track section for each lap. I am using the following formula to work out the maximum lateral G for each corner of each lap based  on the section start and end distances and the telemetry data.
  <a href="https://i.stack.imgur.com/46xqH.png" rel="nofollow noreferrer">Max lateral G formula</a></p>
  <p>I now want to determine the steering angle where the displayed values of lateral G occur. I have tried to use the following formula to find the corresponding steering angle between the defined start and end distances of each track section but it is not working. Note that AH is the steering angle column.
  <a href="https://i.stack.imgur.com/KotLW.png" rel="nofollow noreferrer">Corresponding steering angle formula</a></p>