1 The helmet base form can also be used to create a napkin origami hat for a formal table setting. 2  Fold the bottom point of the helmet base 2/3 of the way to the top. 3  Then, fold this point back onto itself so it is touching the bottom horizontal crease of the napkin. Fold the bottom point of the helmet base 2/3 of the way to the top. 2  Then, fold this point back onto itself so it is touching the bottom horizontal crease of the napkin. 3  If desired, go over these creases with a travel iron to create a crisp look for your folded napkin. 4  Flip the napkin over. 5  Bring the corners together.
The VLOOKUP function is designed to return only the corresponding value of the first instance of a lookup value. But there is a work-around to identify multiple matches. Although VLOOKUP is not used in these array formulas, they are easier to understand and troubleshoot. Table of Contents.
This will tell the LOOKUP function what value to look for in our column. The next value we need to enter is the LOOKUP vector. This is the column or row that Excel must scan to find the value we are searching for. So we want to tell Excel to scan column B from row 6 to 10 to see if it can locate the value we need. Finally the result vector is used to specify the return value if Excel finds the value. The results we want Excel to return in this case is the student name so the result vector in the data is contained in column C 6 to 10.