How do I create a look-up table and use VLOOKUP, LOOKUP, INDEX, HLOOKUP, or a combination to reference for a range of numbers in several categories?

I know how to reference the range with it, but I's have to manually enter the range, and for this assignment it is supposed to be using a look-up table.

Step-by-step please.

Scores Analysis Directive Analytica 113 78 101 91 65 57 58 LEAST PREFERRED LEAST PREFERRED 67 43 50 54 92 51 85 VERY DOMINANT BACKUP 69 86 108 85 116 82 113 97 83 106 73 #N/A 74 65 69 63 10 13 14 15 16 17 18 1. The strensth of each style for each employee and place the appropriate strength in the analysis box 19Use "least prefer 20 2 How many emplovees have at least one "very dominant' style 21 3. The average Conceptual Score of those employees with a "dominant" or "very dominant" conceptual style 22 4. What is the most popular decision style: the style with the most number of times Dominant or Very Dominant occurs. 95 69 67 59 94 65 Using the MASON/MITROFF guidelines below, determine the answers to the following 4 Questions red", "backup, "dominant", and "very dominant" as your strengths 24 | You can use any combination of Excel functions (MATCH, VLOOKUP, H LOOKUP NESTE DIF) that you wish. However, you must use formulas for the 25analvsis and to answer questions 1-4 above. You will have to set up the data from the guidlines how you want MASON & MITROFF Guidelines Style et Eadap Domnart Vey Directive 20-6768-81 82-89 -160 Analytal 20-82 8395 97-104 105-160 Conoeptual 20-72 73-86 87-94 95-160 Behavical 20-47 48-61 62-69 70-160 28 Answer #2 29 Dominant 31 Answer #3 32 34 Answer#4 35 36 37 38 39 40