Using the data below, extract temperature data for the lookup keys in column hH 2 Using the fourth digit in the key, select temperatures from the Temp1 column if the digit is 1.3, Temp2 i the digit is 46 e dig ig 13. femp? f the digit is 4.6 Temp3 if the digit is 7-9. Put the data in the Temperature column next to the Lookup Key 4 5 Ke 6 37T6i58 775X7g10 8 52P7k56 Lookup Key Temperature 77M9165 3904s66 34Y9f10 37M2y4 65L7z10 75G8e79 68W8t54 17U5s92 34W2v61 86Q9u22 28D2s 18 83R7h25 87N9u94 46M3e39 99A4192 11W3n10 43G9m50 75X7g10 14S2a22 96A1138 66V4s54 76P8s93 Temp1 Temp2 Temp3 8.22 16.278 25.106 1.8 80.68 33.76 7.03 672 11.394 9 29N6a46 5.69 25.62 22.526 3.92 7.38 12.87 0 93R7F70 11 12 76T8w41 37A6b176.25 58.5 38.368 0.63 8.97 18.315 13 69P7p92 0.56 1261 19.225 14 94N6g75 4.27 86.76 20.469 3.75 2.09 9.66 15 49K4k87 16 92F5n38 6.53 62.34 2498 17 27E5w73 0.47 25.67 29.313 18 73P4d24 5.05 89.07 10.003 9.7 76.54 3.455 4.38 41.05 14.257 21 62H7264062 36 82 23718 3.53 23 25 32.785 19 36A1c47 20 66S1v18 22 27R8(69 23 7 501s24276 78.57 46947 53H5g18 638 95.91 44 958 4.36 45.72 38.288 293 79.36 28.137 86V9c97 4.52 7363 32.656 25 3302r44 26 38T6q29 27 Sort Lookup1 Lookup2 DateSummary RainfallSummary Reduce Ready Type here to searo