Excel problem

A B C D E F G H 1 Using the data below, extract temperature data for the lookup keys in column H. 2 Using the fourth letter in the key, select temperatures from the Temp1 column if the digit is 1-3, Temp2 if the digit is 4-6 3 and Temp3 if the digit is 7-9. Put the data in the Temperature column next to the Lookup Key. 4 5 Key Temp 1 Temp2 Temp3 Lookup Key Temperature 6 Y4e560 86.46 31.17 10.6 A6m67v 7 C8d91k 35.37 12.33 16.93 W2i57e 8 P9g96s 19.34 17.96 11.8 E5825n 9 Q9r94c 9.78 12.62 12.65 W1531y 10 L4j91h 60.73 48.55 4.96 W8g81e 11 F1w622 86.36 47.38 14.19 LOq97e 12 A0z23p 41.29 34.28 4.28 POq44z 13 W1n40r 62.14 12.23 7.18 R9h68y 14 E0r29b 62.62 10 7.52 F7115g 15 D9c389 77.47 30.59 11.46 T3s71h 16 G7034x 76.95 25.73 P8k66i 17 M5t34b 12.11 47.29 C4e25a 18 Fof52b 75.61 10.49 8.21 R3r83z 19 EOg53p 26.3 19.91 5.64 H5u39u 20 POq44z 42.21 33.31 14.71 01g72h 21 S1s53d 55.66 11.85 15.05 Y9e15v 22 W7b13j 83.7 38.84 6.33 NOq51i 23 N2p39a 44.39 42.72 15.9 07r27g 24 W0g82m 39.57 27.38 6.5 J7a14u 25 P3p61j 33.49 45.83 8.72 Y5c512 26 B9i190 19.8 19.23 6.5 G9b12n 27 T4x48k 77.21 9.81 10.09 S1545v 28 G4b29t 59.8 16.02 8.21 T1084g 29 W2022e 54.52 42.53 9.41 C1f55W 30 L6055j 10.19 11.26 C5p61n 31 B2z86w 30.75 14.47 1.71 H6h81d 22 von771 2022 17 77 7.01 4.79 1.88 10 77 ofoni