Hello all. First post.
I have two design cases, LE and HE and their results as a function of depth. I have these at 95 locations.
I would to plot them, with a lookup function for any one of the locations. So I enter the location into a cell, it finds the depth and LE / HE results for each location.
It worked using a Index () and Match () combo....only it then didnt for any other than the first location.
Also, the results stop at different depths, but the scatter line goes haywire when some of the results become zero...
Help greatly appreciated!
I have two design cases, LE and HE and their results as a function of depth. I have these at 95 locations.
I would to plot them, with a lookup function for any one of the locations. So I enter the location into a cell, it finds the depth and LE / HE results for each location.
It worked using a Index () and Match () combo....only it then didnt for any other than the first location.
Also, the results stop at different depths, but the scatter line goes haywire when some of the results become zero...
Help greatly appreciated!
Book2 | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |||
1 | Reviewed By | ||||||||||||||||||
2 | Location | C02 | Reviewed Date | ||||||||||||||||
3 | Depth | LE | HE | Copied By | |||||||||||||||
4 | C02 | Depth | C02 | LE | C02 | HE | Dated Copied | 12/02/2021 | 12/02/2021 | 12/02/2021 | 12/02/2021 | |||||||||||
5 | 2.4 | 309.69404 | 612.551 | 1 | 2 | 3 | 4 | ||||||||||||
6 | 2.6 | 307.91524 | 608.184 | Note. If text in red. Problem with results. | A02 | B02 | B03 | B04 | |||||||||||
7 | 2.8 | 306.12644 | 603.3 | A02 | Depth | A02 | LE | A02 | HE | B02 | Depth | B02 | LE | B02 | HE | B03 | Depth | B03 | LE | B03 | HE | B04 | Depth | B04 | LE | B04 | HE | ||||
8 | 3 | 304.32964 | 598.001 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||||
9 | 3.2 | 302.52284 | 602.744 | Depth | LE | HE | Depth | LE | HE | Depth | LE | HE | Depth | LE | HE | ||||
10 | 3.4 | 300.70804 | 612.027 | 0 | 8E-05 | 0.00017 | 0 | 9.2E-05 | 0.00019 | 0 | 3.5E-05 | 7E-05 | 0 | 9.2E-05 | 0.00019 | ||||
11 | 3.6 | 298.88324 | 618.712 | 0.2 | 21.6818 | 45.3385 | 0.2 | 24.7793 | 51.0058 | 0.2 | 9.52216 | 18.8685 | 0.2 | 24.7793 | 37.184 | ||||
12 | 3.8 | 297.14674 | 616.921 | 0.4 | 63.5165 | 132.818 | 0.4 | 72.5903 | 149.42 | 0.4 | 27.895 | 55.2748 | 0.4 | 51.9845 | 71.753 | ||||
13 | 4 | 295.30494 | 630.557 | 0.6 | 139.907 | 292.557 | 0.6 | 144.486 | 281.265 | 0.6 | 61.444 | 121.753 | 0.6 | 89.833 | 121.915 | ||||
14 | 4.2 | 293.45514 | 648.392 | 0.8 | 261.247 | 493.372 | 0.8 | 206.451 | 402.349 | 0.8 | 114.734 | 205.663 | 0.8 | 148.555 | 197.126 | ||||
15 | 4.4 | 291.69264 | 671.006 | 1 | 322.373 | 595.51 | 1 | 247.087 | 470.012 | 1 | 158.219 | 236.095 | 1 | 184.881 | 241.373 | ||||
16 | 4.6 | 289.92114 | 664.458 | 1.2 | 320.562 | 643.419 | 1.2 | 257.765 | 488.214 | 1.2 | 157.377 | 233.797 | 1.2 | 191.473 | 247.513 | ||||
17 | 4.8 | 288.14064 | 690.18 | 1.4 | 318.742 | 639.063 | 1.4 | 271.066 | 511.904 | 1.4 | 156.583 | 231.188 | 1.4 | 200.664 | 256.37 | ||||
18 | 5 | 286.35214 | 727.325 | 1.6 | 317.009 | 631.028 | 1.6 | 288.318 | 542.956 | 1.6 | 155.724 | 228.931 | 1.6 | 208.738 | 263.813 | ||||
19 | 5.2 | 284.55564 | 767.431 | 1.8 | 315.17 | 627.092 | 1.8 | 311.383 | 584.289 | 1.8 | 154.913 | 226.583 | 1.8 | 221.898 | 276.76 | ||||
20 | 5.4 | 282.75014 | 766.647 | 2 | 313.322 | 622.737 | 2 | 343.755 | 643.547 | 2 | 154.096 | 224.072 | 2 | 236.608 | 291.415 | ||||
21 | 5.6 | 280.93664 | 837.182 | 2.2 | 311.561 | 617.869 | 2.2 | 392.42 | 711.653 | 2.2 | 153.269 | 221.765 | 2.2 | 255.751 | 310.225 | ||||
22 | 5.8 | 279.11414 | 943.329 | 2.4 | 309.694 | 612.551 | 2.4 | 431.586 | 707.483 | 2.4 | 152.434 | 219.442 | 2.4 | 280.537 | 335.258 | ||||
23 | 6 | 277.37994 | 934.629 | 2.6 | 307.915 | 608.184 | 2.6 | 464.53 | 712.71 | 2.6 | 151.648 | 216.884 | 2.6 | 318.567 | 377.04 | ||||
24 | 6.2 | 275.54144 | 1079.66 | 2.8 | 306.126 | 603.3 | 2.8 | 465.463 | 857.938 | 2.8 | 150.798 | 214.603 | 2.8 | 374.154 | 437.69 | ||||
25 | 6.4 | 273.79124 | 1087.87 | 3 | 304.33 | 598.001 | 3 | 614.777 | 982.819 | 3 | 149.94 | 212.307 | 3 | 452.469 | 532.94 | ||||
26 | 6.6 | 271.93674 | 1152.75 | 3.2 | 302.523 | 602.744 | 3.2 | 611.183 | 1050.44 | 3.2 | 149.131 | 209.849 | 3.2 | 449.557 | 632.486 | ||||
27 | 6.8 | 270.16954 | 1271.95 | 3.4 | 300.708 | 612.027 | 3.4 | 612.399 | 1114.08 | 3.4 | 148.257 | 207.522 | 3.4 | 446.771 | 627.911 | ||||
28 | 7 | 268.39534 | 1268.83 | 3.6 | 298.883 | 618.712 | 3.6 | 678.017 | 1323.32 | 3.6 | 147.432 | 205.254 | 3.6 | 443.841 | 621.971 | ||||
29 | 7.2 | 266.61214 | 1365.83 | 3.8 | 297.147 | 616.921 | 3.8 | 701.317 | 1360.12 | 3.8 | 146.601 | 202.75 | 3.8 | 441.038 | 617.086 | ||||
30 | 7.4 | 264.82094 | 1416.17 | 4 | 295.305 | 630.557 | 4 | 718.783 | 1402.58 | 4 | 145.76 | 200.525 | 4 | 438.224 | 611.216 | ||||
31 | 7.6 | 263.11904 | 1711.87 | 4.2 | 293.455 | 648.392 | 4.2 | 742.433 | 1439.73 | 4.2 | 144.913 | 198.286 | 4.2 | 435.402 | 606.126 | ||||
32 | 7.8 | 261.40514 | 1933.65 | 4.4 | 291.693 | 671.006 | 4.4 | 766.515 | 1476.88 | 4.4 | 144.058 | 195.813 | 4.4 | 432.572 | 600.644 | ||||
33 | 8 | 259.59094 | 1972.57 | 4.6 | 289.921 | 664.458 | 4.6 | 787.269 | 1514.03 | 4.6 | 143.196 | 193.544 | 4.6 | 429.732 | 597.582 | ||||
34 | 8.2 | 257.86504 | 2023.24 | 4.8 | 288.141 | 690.18 | 4.8 | 808.023 | 1558.26 | 4.8 | 142.383 | 191.336 | 4.8 | 426.883 | 606.405 | ||||
35 | 8.4 | 256.03484 | 2062.52 | 5 | 286.352 | 727.325 | 5 | 832.889 | 1595.77 | 5 | 141.506 | 188.894 | 5 | 424.161 | 598.965 | ||||
36 | 8.6 | 254.29394 | 2101.79 | 5.2 | 284.556 | 767.431 | 5.2 | 853.838 | 1633.27 | 5.2 | 140.678 | 186.657 | 5.2 | 421.295 | 611.083 | ||||
37 | 8.8 | 252.54604 | 2063.66 | 5.4 | 282.75 | 766.647 | 5.4 | 874.788 | 1673.59 | 5.4 | 139.787 | 184.406 | 5.4 | 256.446 | 617.384 | ||||
38 | 9 | 250.78914 | 2110.86 | 5.6 | 280.937 | 837.182 | 5.6 | 900.437 | 1716.78 | 5.6 | 138.945 | 181.996 | 5.6 | 264.835 | 616.938 | ||||
39 | 9.2 | 249.02524 | 2233.14 | 5.8 | 279.114 | 943.329 | 5.8 | 921.582 | 1754.64 | 5.8 | 138.096 | 179.793 | 5.8 | 271.666 | 633.649 | ||||
40 | 9.4 | 247.25434 | 2272.77 | 6 | 277.38 | 934.629 | 6 | 942.728 | 1801.69 | 6 | 140.876 | 182.788 | 6 | 278.497 | 633.826 | ||||
41 | 9.6 | 245.47544 | 2326.63 | 6.2 | 275.541 | 1079.66 | 6.2 | 935.441 | 1839.91 | 6.2 | 142.032 | 184.155 | 6.2 | 287.138 | 646.212 | ||||
42 | 9.8 | 243.78584 | 2366.61 | 6.4 | 273.791 | 1087.87 | 6.4 | 964.195 | 1878.12 | 6.4 | 144.813 | 187.14 | 6.4 | 294.031 | 669.953 | ||||
43 | 10 | 241.99294 | 2369.39 | 6.6 | 271.937 | 1152.75 | 6.6 | 1011.84 | 1916.33 | 6.6 | 147.596 | 190.121 | 6.6 | 300.925 | 663.682 | ||||
44 | 10.2 | 240.28834 | 2461.87 | 6.8 | 270.17 | 1271.95 | 6.8 | 1033.18 | 1917.22 | 6.8 | 148.743 | 191.459 | 6.8 | 309.816 | 698.127 | ||||
45 | 10.4 | 238.48044 | 2502.21 | 7 | 268.395 | 1268.83 | 7 | 1060.59 | 2003.73 | 7 | 151.527 | 194.43 | 7 | 316.772 | 714.21 | ||||
46 | 10.6 | 236.76184 | 2542.54 | 7.2 | 266.612 | 1365.83 | 7.2 | 1082.13 | 2013.27 | 7.2 | 152.664 | 195.748 | 7.2 | 323.729 | 719.64 | ||||
47 | 10.8 | 235.03624 | 2582.88 | 7.4 | 264.821 | 1416.17 | 7.4 | 1103.67 | 2084.88 | 7.4 | 155.45 | 198.709 | 7.4 | 332.87 | 723.995 | ||||
48 | 11 | 236.41977 | 2639.92 | 7.6 | 263.119 | 1711.87 | 7.6 | 1115.1 | 2131.46 | 7.6 | 156.579 | 200.007 | 7.6 | 339.889 | 788.162 | ||||
49 | 11.2 | 237.49118 | 2680.61 | 7.8 | 261.405 | 1933.65 | 7.8 | 1153.6 | 2170.38 | 7.8 | 159.365 | 202.959 | 7.8 | 346.908 | 777.382 | ||||
50 | 11.4 | 238.86071 | 2721.3 | 8 | 259.591 | 1972.57 | 8 | 1175.33 | 2161.35 | 8 | 160.485 | 204.239 | 8 | 356.301 | 820.656 | ||||
51 | 11.6 | 240.22324 | 2779.76 | 8.2 | 257.865 | 2023.24 | 8.2 | 1204.31 | 2261.32 | 8.2 | 163.272 | 207.181 | 8.2 | 363.382 | 846.132 | ||||
52 | 11.8 | 241.27464 | 2820.81 | 8.4 | 256.035 | 2062.52 | 8.4 | 1223.4 | 2296.13 | 8.4 | 166.064 | 210.122 | 8.4 | 372.963 | 844.658 | ||||
53 | 12 | 242.62317 | 2861.85 | 8.6 | 254.294 | 2101.79 | 8.6 | 1398.97 | 2331.05 | 8.6 | 167.175 | 211.377 | 8.6 | 374.305 | 869.32 | ||||
54 | 12.2 | 243.9647 | 2901.09 | 8.8 | 252.546 | 2063.66 | 8.8 | 1426.13 | 2379.99 | 8.8 | 169.968 | 214.31 | 8.8 | 371.696 | 885.876 | ||||
55 | 12.4 | 244.99611 | 2963.12 | 9 | 250.789 | 2110.86 | 9 | 1883.13 | 2415.22 | 9 | 171.07 | 215.548 | 9 | 368.944 | 899.283 | ||||
56 | 12.6 | 246.32464 | 3004.52 | 9.2 | 249.025 | 2233.14 | 9.2 | 1308.25 | 2450.44 | 9.2 | 173.865 | 218.473 | 9.2 | 366.32 | 950.881 | ||||
57 | 12.8 | 247.34204 | 3045.92 | 9.4 | 247.254 | 2272.77 | 9.4 | 1327.61 | 2485.67 | 9.4 | 174.744 | 219.417 | 9.4 | 363.645 | 940.03 | ||||
58 | 13 | 248.65657 | 3107.56 | 9.6 | 245.475 | 2326.63 | 9.6 | 1355.41 | 2536.19 | 9.6 | 177.539 | 222.334 | 9.6 | 361.005 | 1009.94 | ||||
59 | 13.2 | 249.66098 | 3149.31 | 9.8 | 243.786 | 2366.61 | 9.8 | 1377.73 | 2571.4 | 9.8 | 178.626 | 223.539 | 9.8 | 358.358 | 1090.93 | ||||
60 | 13.4 | 250.96351 | 3191.07 | 10 | 241.993 | 2369.39 | 10 | 1400.05 | 2616.15 | 10 | 181.422 | 226.45 | 10 | 355.568 | 1094.21 | ||||
61 | 13.6 | 252.25904 | 3254.13 | 10.2 | 240.288 | 2461.87 | 10.2 | 1431.41 | 2672.49 | 10.2 | 182.503 | 227.639 | 10.2 | 352.905 | 1156.91 | ||||
62 | 13.8 | 253.24444 | 3296.23 | 10.4 | 238.48 | 2502.21 | 10.4 | 1453.92 | 2712.82 | 10.4 | 185.079 | 230.26 | 10.4 | 350.371 | 1220.25 | ||||
63 | 14 | 254.52697 | 3338.34 | 10.6 | 236.762 | 2542.54 | 10.6 | 1476.44 | 2753.16 | 10.6 | 187.879 | 233.163 | 10.6 | 347.693 | 1207.99 | ||||
64 | 14.2 | 255.49938 | 3380.44 | 10.8 | 235.036 | 2582.88 | 10.8 | 1508.57 | 2793.5 | 10.8 | 188.951 | 234.333 | 10.8 | 345.009 | 1447.72 | ||||
65 | 14.4 | 256.76991 | 3445.27 | 11 | 236.42 | 2639.92 | 11 | 927.527 | 1676.16 | 11 | 191.755 | 237.23 | 11 | 342.317 | 1856.88 | ||||
66 | 14.6 | 257.73031 | 3487.73 | 11.2 | 237.491 | 2680.61 | 11.2 | 942.192 | 1701.71 | 11.2 | 192.592 | 238.097 | 11.2 | 339.753 | 1899.55 | ||||
67 | 14.8 | 258.68372 | 3530.19 | 11.4 | 238.861 | 2721.3 | 11.4 | 963.389 | 1738.77 | 11.4 | 195.395 | 240.988 | 11.4 | 336.954 | 2230.85 | ||||
68 | 15 | 259.93525 | 3596.43 | 11.6 | 240.223 | 2779.76 | 11.6 | 978.179 | 1764.54 | 11.6 | 196.455 | 242.131 | 11.6 | 334.376 | 3110.29 | ||||
69 | 15.2 | 260.87765 | 3639.25 | 11.8 | 241.275 | 2820.81 | 11.8 | 992.969 | 1790.31 | 11.8 | 199.028 | 244.725 | 11.8 | 331.79 | 3179.57 | ||||
70 | 15.4 | 414.35834 | 14304.1 | 12 | 242.623 | 2861.85 | 12 | 1014.67 | 1828.25 | 12 | 200.08 | 245.855 | 12 | 331.309 | 3164.48 | ||||
71 | 15.6 | 440.40734 | 2344.57 | 12.2 | 243.965 | 2901.09 | 12.2 | 1029.58 | 1854.24 | 12.2 | 202.888 | 248.738 | 12.2 | 332.932 | 3261.66 | ||||
72 | 15.8 | 477.23834 | 2387.35 | 12.4 | 244.996 | 2963.12 | 12.4 | 1712.64 | 3176.93 | 12.4 | 205.462 | 251.323 | 12.4 | 334.122 | 3324.21 | ||||
73 | 16 | 532.94234 | 2414.66 | 12.6 | 246.325 | 3004.52 | 12.6 | 1747.12 | 3218.32 | 12.6 | 206.507 | 252.438 | 12.6 | 335.731 | 3365.61 | ||||
74 | 16.2 | 626.41234 | 2441.98 | 12.8 | 247.342 | 3045.92 | 12.8 | 1770.42 | 3259.72 | 12.8 | 209.08 | 255.016 | 12.8 | 336.908 | 3407.01 | ||||
75 | 16.4 | 814.31534 | 2469.29 | 13 | 248.657 | 3107.56 | 13 | 1793.72 | 3322.43 | 13 | 210.119 | 256.119 | 13 | 338.503 | 3470.97 | ||||
76 | 16.6 | 1379.9873 | 2513.17 | 13.2 | 249.661 | 3149.31 | 13.2 | 1817.02 | 3364.18 | 13.2 | 212.691 | 258.691 | 13.2 | 339.666 | 3512.72 | ||||
77 | 16.8 | 1425.7443 | 2540.71 | 13.4 | 250.964 | 3191.07 | 13.4 | 1852.48 | 3369.22 | 13.4 | 213.725 | 259.784 | 13.4 | 341.248 | 13885.4 | ||||
78 | 17 | 1441.6622 | 2568.24 | 13.6 | 252.259 | 3254.13 | 13.6 | 1875.97 | 3470.05 | 13.6 | 216.542 | 262.657 | 13.6 | 342.823 | 1033.74 | ||||
79 | 17.2 | 1457.5801 | 2613 | 13.8 | 253.244 | 3296.23 | 13.8 | 1899.47 | 3512.16 | 13.8 | 217.324 | 263.433 | 13.8 | 343.965 | 1046.66 | ||||
80 | 17.4 | 1483.3684 | 2640.75 | 14 | 254.527 | 3338.34 | 14 | 1912.48 | 3554.26 | 14 | 220.142 | 266.303 | 14 | 345.527 | 1066.88 | ||||
81 | 17.6 | 1499.4116 | 2668.51 | 14.2 | 255.499 | 3380.44 | 14.2 | 1959.41 | 3596.37 | 14.2 | 220.917 | 267.067 | 14.2 | 346.657 | 1079.92 | ||||
82 | 17.8 | 1517.4603 | 2717.26 | 14.4 | 256.77 | 3445.27 | 14.4 | 1983.1 | 3662.26 | 14.4 | 223.737 | 269.936 | 14.4 | 348.204 | 1092.95 | ||||
83 | 18 | 1545.7866 | 2748.34 | 14.6 | 257.73 | 3487.73 | 14.6 | 2020.13 | 3704.72 | 14.6 | 226.309 | 272.495 | 14.6 | 349.322 | 1113.59 | ||||
84 | 18.2 | 1563.9763 | 2779.42 | 14.8 | 258.684 | 3530.19 | 14.8 | 2044.01 | 3747.18 | 14.8 | 227.075 | 273.243 | 14.8 | 350.432 | 1126.73 | ||||
85 | 18.4 | 1582.166 | 2829.16 | 15 | 259.935 | 3596.43 | 15 | 2067.9 | 3814.48 | 15 | 260.699 | 309.584 | 15 | 351.96 | 1147.69 | ||||
86 | 18.6 | 1611.0563 | 2860.48 | 15.2 | 260.878 | 3639.25 | 15.2 | 2105.71 | 3857.3 | 15.2 | 267.275 | 316.312 | 15.2 | 353.057 | 1160.94 | ||||
87 | 18.8 | 1629.387 | 2891.81 | 15.4 | 414.358 | 14304.1 | 15.4 | 2129.79 | 3900.11 | 15.4 | 276.005 | 325.25 | 15.4 | 354.574 | 1174.18 | ||||
88 | 19 | 1647.7177 | 2942.52 | 15.6 | 440.407 | 2344.57 | 15.6 | 2153.88 | 3942.92 | 15.6 | 282.606 | 331.991 | 15.6 | 355.659 | 1195.57 | ||||
89 | 19.2 | 1675.1196 | 2970.93 | 15.8 | 477.238 | 2387.35 | 15.8 | 2192.47 | 4012 | 15.8 | 289.559 | 339.139 | 15.8 | 357.164 | 1208.92 | ||||
90 | 19.4 | 1691.5389 | 2999.35 | 16 | 532.942 | 2414.66 | 16 | 2216.75 | 4055.16 | 16 | 298.013 | 347.721 | 16 | 414.259 | 1222.27 | ||||
91 | 19.6 | 1707.9582 | 3027.76 | 16.2 | 626.412 | 2441.98 | 16.2 | 2241.03 | 4098.33 | 16.2 | 304.648 | 354.478 | 16.2 | 424.478 | 1244.08 | ||||
92 | 19.8 | 1735.8615 | 3076.44 | 16.4 | 814.315 | 2469.29 | 16.4 | 2265.31 | 4168.82 | 16.4 | 311.658 | 361.666 | 16.4 | 437.4 | 1257.54 | ||||
93 | 20 | 1752.4061 | 3105.08 | 16.6 | 1379.99 | 2513.17 | 16.6 | 2304.88 | 4212.34 | 16.6 | 320.154 | 370.275 | 16.6 | 453.833 | 1271 | ||||
94 | 20.2 | 1768.9507 | 3133.71 | 16.8 | 1425.74 | 2540.71 | 16.8 | 2329.36 | 4255.86 | 16.8 | 326.822 | 377.049 | 16.8 | 475.288 | 1293.23 | ||||
95 | 20.4 | 1797.3554 | 3183.27 | 17 | 1441.66 | 2568.24 | 17 | 2353.83 | 4299.38 | 17 | 333.889 | 384.279 | 17 | 504.283 | 1306.79 | ||||
96 | 20.6 | 1814.0253 | 3212.12 | 17.2 | 1457.58 | 2613 | 17.2 | 2394.19 | 4371.64 | 17.2 | 342.43 | 392.916 | 17.2 | 545.352 | 1320.36 | ||||
97 | 0 | 0 | 0 | 17.4 | 1483.37 | 2640.75 | 17.4 | 2418.86 | 4415.52 | 17.4 | 349.131 | 399.708 | 17.4 | 607.559 | 1343.01 | ||||
98 | 0 | 0 | 0 | 17.6 | 1499.41 | 2668.51 | 17.6 | 2443.53 | 4459.39 | 17.6 | 356.258 | 406.981 | 17.6 | 712.34 | 2108.91 | ||||
99 | 0 | 0 | 0 | 17.8 | 1517.46 | 2717.26 | 17.8 | 2487.78 | 4537.98 | 17.8 | 364.842 | 415.647 | 17.8 | 922.681 | 2129.76 | ||||
100 | 0 | 0 | 0 | 18 | 1545.79 | 2748.34 | 18 | 2515.75 | 4587.12 | 18 | 1640.78 | 2894.43 | 18 | 1242.86 | 2150.61 | ||||
101 | 0 | 0 | 0 | 18.2 | 1563.98 | 2779.42 | 18.2 | 2543.72 | 4636.26 | 18.2 | 1656.95 | 2922.4 | 18.2 | 1255.1 | 2186.08 | ||||
102 | 0 | 0 | 0 | 18.4 | 1582.17 | 2829.16 | 0 | 18.4 | 1673.11 | 2970.13 | 18.4 | 1267.35 | 2207.1 | ||||||
RESULTS |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A4:C4 | A4 | =$B$2&" | "&A3 |
A5:A102 | A5 | =INDEX($F10:$JO$506, MATCH($B$2,$F$6:$KG$6,0),MATCH($A$3,$F$9:$KG$9,0)) |
B5:B102 | B5 | =INDEX($F10:$JO$506, MATCH($B$2,$F$6:$KG$6,0),MATCH($B$3,$F$9:$KG$9,0)) |
C5:C102 | C5 | =INDEX($F10:$JO$506, MATCH($B$2,$F$6:$KG$6,0),MATCH($C$3,$F$9:$KG$9,0)) |
F7,I7,L7,O7 | F7 | =F6&" | "&F9 |
G7,J7,M7,P7 | G7 | =F6&" | "&G9 |
H7,K7,N7,Q7 | H7 | =F6&" | "&H9 |