'How to extract a cell that's row and column meet a criteria in Excel
In the attached image, I have a table exported from the Motec i2 telementery software which states the start and finishing distance (cumulative) for some select corners and the sections between them.
In the table I have started below, I want to summarise this data in a more condensed form. For example for cell D10 (which shows the start of lap 1 turn 2) this should look in the table above and extract the cell where the column contains values "Lap 1" and "Turn2" and the row contains "Start". Is there a way I can do this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|