Using BASIC excel functions, write a function that will answer the above question, based on the data.

Home Insert Page Layout Formulas Data Review View Wrap Text Genera Copy Paste -Merge & Center K1 1 Using the data below, extract temperature data for the lookup keys in column H 2 Using the fourth digit 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 ture 3 10 93R7f70 1 1 9 5 1 2 3