Create a Named Constant Arrayīring up the Define Name dialog box and type in the name GradeLookup. This formula does not need to reference a separate Grade Lookup Table on a worksheet because all the values are located in the named array constant, GradeLookup, which is now located in Excel’s internal memory. However, instead of typing this into the formula each time, we can create a Named Constant in the Define Name dialog box shown below.īy creating GradeLookup as a named constant array, the formula can be shortened to: In the formula above, the second argument, GradeLU, could be replaced with the following: The Grade Lookup Table can be replaced with an array constant. This is what allows a score of 72 to be matched to 70 and consequently return a letter grade of C. The TRUE means the student score will be approximately matched to the first column from GradeLU. The two ( 2) means that a number from the second column will be returned from GradeLU. GradeLU is the Grade Lookup Table that’s on another worksheet and is a named range. Score refers to the student score that’s being looked up.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |