I have a table of data with column headings. I want to extract cell data in row 10 from a specific column to use in a formula. I want to reference column 31/12/2021 and select cell L18.
| Thomson share assets.xlsm | ||||||||
|---|---|---|---|---|---|---|---|---|
| K | L | M | N | O | P | |||
| 1 | 31-Jan-22 | 31-Dec-21 | 30-Nov-21 | 31-Oct-21 | 30-Sep-21 | 31-Aug-21 | ||
| 2 | 346.00 | 354.50 | 342.00 | 331.00 | 309.00 | 319.00 | ||
| 3 | 624.80 | 892.80 | 908.00 | 863.20 | 777.00 | 854.00 | ||
| 4 | 495.00 | 518.00 | 528.00 | 496.50 | 529.00 | 557.00 | ||
| 5 | 664.00 | 590.00 | 560.00 | 708.00 | 685.00 | 759.00 | ||
| 6 | 185.00 | 180.00 | 175.00 | 169.50 | 174.00 | 154.50 | ||
| 7 | 13.39 | 13.92 | 14.34 | 13.95 | 13.67 | 14.17 | ||
| 8 | 4,696.50 | 5,286.50 | 5,178.00 | 5,105.00 | 4,858.00 | 5,119.00 | ||
| 9 | 10,935.00 | 10,273.00 | 10,110.50 | 10,186.00 | 10,067.50 | 10,968.50 | ||
| 10 | 49,200.00 | 50,200.00 | 49,850.00 | 49,300.00 | 48,750.00 | 49,400.00 | ||
| 11 | 3,787.50 | 3,945.50 | 3,859.00 | 3,912.00 | 3,973.00 | 4,046.00 | ||
| 12 | 346.00 | 354.50 | 342.00 | 331.00 | 309.00 | 319.00 | ||
| 13 | 4,696.50 | 5,286.50 | 5,178.00 | 5,105.00 | 4,858.00 | 5,119.00 | ||
| 14 | 49,200.00 | 50,200.00 | 49,850.00 | 49,300.00 | 48,750.00 | 49,400.00 | ||
| 15 | ||||||||
| 16 | ||||||||
| 17 | ||||||||
| 18 | 285,011.12 | 298,376.42 | 292,533.22 | 287,397.98 | 278,099.87 | 284,456.23 | ||
| 19 | ||||||||
| 20 | 36,511.34 | 49,876.64 | 44,033.44 | 38,898.20 | 29,600.09 | 35,956.45 | ||
Summary | ||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| K18:P18 | K18 | =IF(K2="","",(SUMPRODUCT(K2:K6,$B$2:$B$6)+SUMPRODUCT(K8:K14,$B$8:$B$14))/100+K7*$B$7) |
| K20:P20 | K20 | =IF(K18="","",K18-$X$18) |
