Spreadsheet: 191666d1352175844-combine-iferror-and-vlookup-am-in-barking-up-the-wrong-tree-here-example-1
Sheet: Sheet2

 | Marathon 3DL |  |  | 100% Aramid |  |  | [NAME] |  |  |  |  |  |  | 100% Carbon |  | 3Di
DPI | Marathon 600 (100% Aramid) | Marathon 680 (40% IRC Carb / 60% Aramid) | Marathon 860SY (50% IRC Carb / 50% Aramid) | 600s (100% [NAME]) | 3DL 600 (100% Aramid M) | Race 600 (100% Aramid L) | 680s (30% IRC Carb /70% aramid) | 3DL 680 (30% IRC Carb /70% aramid) | 860 (50% IRC Carb /50% aramid) | Race 860 (70% IRC Carbon/30% aramid) | 860 SY (55% Carbon/45% Aramid) | 960 (70% AC Carbon/ 30% aramid) | 960 SY (55% AC Carbon/45% aramid) | 800 (100% IRC Carbon) | 900 (100% IACC Carbon) | 760i (50% Aramid /50% Dyneema) | 780i (50% Carbon/ 50% Dyneema) | 870i (70% Carbon / 30% Dyneema)
6300 |  | 45.7758 | 47.36230176211453 | 37.9156718061674 | 42.82759030837005 | 45.08167400881057 | 43.61687444933921 | 46.79382290748899 | 47.68893832599118 | 48.78118387665199 | 47.99899585903084 | 55.431639 | 52.43770665198239 | 50.7552422907489 | 56.27583039647576 | 56.27583039647576 | 56.27583039647576 | 56.27583039647576
7560 | 44.23718061674009 | 54.10335647577092 | 56.01841850220264 | 44.53608370044053 | 50.43038590308371 | 53.08461674008811 | 51.45071629955947 | 55.26305444933921 | 56.40475242290749 | 57.76836866960353 | 56.79033335682819 | 65.73078635947137 | 62.11678630837005 | 60.19691629955948 | 66.84076387665198 | 66.84076387665198 | 66.84076387665198 | 66.84076387665198
8820 | 50.90629955947136 | 62.43091295154185 | 64.67453524229074 | 51.15649559471366 | 58.03318149779736 | 61.08755947136564 | 59.28455814977974 | 63.73228599118943 | 65.12056651982378 | 66.75555346255507 | 65.58167085462556 | 76.02993371894273 | 71.79586596475771 | 69.63859030837004 | 77.40569735682818 | 77.40569735682818 | 77.40569735682818 | 77.40569735682818
10850 | 61.65099118942732 | 75.84753171806167 | 78.62050110132158 | 61.82271475770926 | 70.28212995594714 | 73.98118942731277 | 71.90574779735682 | 77.377159030837 | 79.16271145374449 | 81.2349067400881 | 79.74549237885464 | 92.62300446475768 | 87.38993874449339 | 84.85017621145374 | 94.42697907488986 | 94.42697907488986 | 94.42697907488986 | 94.42697907488986
12600 | 70.9136563876652 | 87.41358237885463 | 90.64288546255507 | 71.01773127753304 | 80.84156828193834 | 85.09638766519824 | 82.78608370044053 | 89.13998061674009 | 91.2680088105727 | 93.7171078414097 | 91.95568334801763 | 106.9273757973568 | 100.8331049339207 | 97.96361233480175 | 109.1004977973568 | 109.1004977973568 | 109.1004977973568 | 109.1004977973568
14700 | 82.02885462555066 | 101.2928431718062 | 105.0697466960352 | 82.05175110132159 | 93.51289427312776 | 98.4346255506608 | 95.84248678414096 | 103.2553665198238 | 105.7943656387665 | 108.6957491629956 | 106.6079125110132 | 124.0926213964758 | 116.9649043612335 | 113.6997356828194 | 126.7087202643172 | 126.7087202643172 | 126.7087202643172 | 126.7087202643172
16800 | 93.14405286343612 | 115.1721039647577 | 119.4966079295154 | 93.08577092511014 | 106.1842202643172 | 111.7728634361233 | 108.8988898678414 | 117.3707524229075 | 120.3207224669603 | 123.6743904845815 | 121.2601416740088 | 141.2578669955947 | 133.0967037885463 | 129.435859030837 | 144.3169427312775 | 144.3169427312775 | 144.3169427312775 | 144.3169427312775
19600 | 107.9643171806167 | 133.6777850220264 | 138.732422907489 | 107.7977973568282 | 123.0793215859031 | 129.5571806167401 | 126.3074273127753 | 136.1912669603524 | 139.6891982378854 | 143.645912246696 | 140.7964472246696 | 164.1448611277533 | 154.60576969163 | 150.4173568281938 | 167.7945726872246 | 167.7945726872246 | 167.7945726872246 | 167.7945726872246
22400 | 122.7845814977973 | 152.1834660792952 | 157.9682378854625 |  | 139.974422907489 | 147.3414977973568 |  | 155.2892511013216 | 159.0576740088106 | 163.6174340088105 | 160.3327527753304 | 187.0318552599119 | 176.1148355947137 | 171.3988546255507 | 191.2722026431718 | 191.2722026431718 | 191.2722026431718 | 191.2722026431718
23800 | 130.1947136563876 | 161.4363066079295 | 167.5861453744493 |  | 148.4219735682819 | 156.2336563876652 |  | 164.7309251101322 | 168.7419118942731 | 173.6031948898679 | 170.1009055506608 | 198.4753523259912 | 186.8693685462555 | 181.8896035242291 | 203.0110176211454 | 203.0110176211454 | 203.0110176211454 | 203.0110176211454
26000 | 141.8392070484581 | 175.9764845814978 | 182.7 |  | 161.6966960352423 | 170.2070484581498 |  | 179.5678414096916 | 183.96 | 189.295104845815 | 185.4508599118943 | 216.4579905726872 | 203.7693488986784 | 198.3750660792952 | 221.4577268722467 | 221.4577268722467 | 221.4577268722467 | 221.4577268722467
29400 | 159.8352422907489 | 198.4476687224669 | 206.0577753303965 |  | 182.2121762114538 | 191.8022907488987 |  | 202.4976211453744 | 207.4788634361233 | 213.5462384140969 | 209.1735166519824 | 244.2493405903084 | 229.8875003524229 | 223.8525991189427 | 249.9662775330396 | 249.9662775330396 | 249.9662775330396 | 249.9662775330396
32200 | 174.6555066079295 | 216.9533497797357 | 225.2935903083701 |  | 199.1072775330397 | 209.5866079295154 |  | 221.3809691629956 | 226.8473392070485 | 233.5177601762115 | 228.7098222026432 | 267.1363347224669 | 251.3965662555066 | 244.8340969162996 | 273.4439074889868 | 273.4439074889868 | 273.4439074889868 | 273.4439074889868
35000 | 189.4757709251101 | 235.4590308370044 | 244.5294052863436 |  | 216.0023788546256 | 227.3709251101322 |  | 240.2643171806167 | 246.2158149779735 | 253.489281938326 | 248.246127753304 | 290.0233288546255 | 272.9056321585903 | 265.8155947136564 | 296.9215374449338 | 296.9215374449338 | 296.9215374449338 | 296.9215374449338
37200 |  |  | 259.6432599118942 |  | 229.2771013215859 | 241.3443171806167 |  |  | 261.4339030837004 | 269.1811918942731 | 263.5960821145375 | 308.0059671013215 | 289.8056125110132 | 282.3010572687225 | 315.3682466960352 | 315.3682466960352 | 315.3682466960352 | 315.3682466960352
39800 |  |  | 277.5050881057268 |  | 244.96540969163 | 257.8583259911894 |  |  | 279.4189162995594 | 287.7261763876652 | 281.7369372687225 | 329.2581759383259 | 309.7783165638766 | 301.7838766519824 | 337.1689030837004 | 337.1689030837004 | 337.1689030837004 | 337.1689030837004
42400 |  |  | 295.3669162995595 |  | 260.6537180616741 | 274.3723348017621 |  |  | 297.4039295154185 | 306.2711608810572 | 299.8777924229075 | 350.5103847753303 | 329.75102061674 | 321.2666960352423 | 358.9695594713656 | 358.9695594713656 | 358.9695594713656 | 358.9695594713656
45000 |  |  | 313.2287444933921 |  | 276.3420264317181 | 290.8863436123348 |  |  | 315.3889427312776 | 324.8161453744493 | 318.0186475770925 | 371.7625936123347 | 349.7237246696035 | 340.7495154185022 | 380.7702158590308 | 380.7702158590308 | 380.7702158590308 | 380.7702158590308
47600 |  |  | 331.0905726872246 |  | 292.0303348017621 | 307.4003524229075 |  |  | 333.3739559471365 | 343.3611298678414 | 336.1595027312775 | 393.0148024493392 | 369.696428722467 | 360.2323348017621 | 402.570872246696 | 402.570872246696 | 402.570872246696 | 402.570872246696
50200 |  |  | 348.9524008810573 |  | 307.7186431718062 | 323.9143612334802 |  |  | 351.3589691629955 | 361.9061143612334 | 354.3003578854627 | 414.2670112863436 | 389.6691327753305 | 379.7151541850221 | 424.3715286343612 | 424.3715286343612 | 424.3715286343612 | 424.3715286343612
52800 |  |  | 366.8142290748899 |  | 323.4069515418502 | 340.4283700440528 |  |  | 369.3439823788546 | 380.4510988546256 | 372.4412130396477 | 435.519220123348 | 409.6418368281938 | 399.1979735682819 | 446.1721850220264 | 446.1721850220264 | 446.1721850220264 | 446.1721850220264
55400 |  |  | 384.6760572687224 |  | 339.0952599118943 | 356.9423788546255 |  |  | 387.3289955947136 | 398.9960833480177 | 390.5820681938326 | 456.7714289603525 | 429.6145408810573 | 418.6807929515418 | 467.9728414096916 | 467.9728414096916 | 467.9728414096916 | 467.9728414096916
58000 |  |  | 402.537885462555 |  | 354.7835682819384 | 373.4563876651982 |  |  | 405.3140088105727 | 417.5410678414096 | 408.7229233480177 | 478.0236377973568 | 449.5872449339207 | 438.1636123348018 | 489.7734977973568 | 489.7734977973568 | 489.7734977973568 | 489.7734977973568
60600 |  |  | 420.3997136563876 |  | 370.4718766519824 | 389.9703964757709 |  |  | 423.2990220264317 | 436.0860523348018 | 426.8637785022026 | 499.2758466343613 | 469.5599489867841 | 457.6464317180616 | 511.5741541850219 | 511.5741541850219 | 511.5741541850219 | 511.5741541850219
63200 |  |  | 438.2615418502203 |  |  |  |  |  |  | 454.6310368281938 | 445.0046336563877 |  |  | 477.1292511013216 |  | 533.3748105726872 | 533.3748105726872 | 533.3748105726872
65800 |  |  | 456.1233700440528 |  |  |  |  |  |  | 473.1760213215859 | 463.1454888105727 |  |  | 496.6120704845815 |  | 555.1754669603524 | 555.1754669603524 | 555.1754669603524