CS100 Lecture Notes - Lecture 3: Lookup Table, Wildcard Character, Indirection
Document Summary
More specifically, by the end of the module, you will be able to: use vlookup with either exact or inexact matching, use the indirect function lay out and format a spreadsheet for effective display and maintenance. Label pattern: when labels follow a similar pattern to the search key. Search key is the lookup value to be found in a table. Use-independent input are static inputs that allow formulas to reference to it. Use-specific input are variable input that affect the computation. Whitespace spaces between cluster of data to indicate relevancy. Wildcard character (? and *) can be used in find/replace, search, match and lookup functions, and act as single or multiple characters in labels. Using ~ or tildes as a marker to indicate that the next character is a literal. Vlookup provides the ability to look up values in a table.