CSE 1113 Lecture 3: Reference Functions
Document Summary
Finds an entry from a vertical array based on a criteria. Col_index_num: the column number in your range that contains the corresponding data: range_lookup: Finds an entry from a horizontal array based on a criteria. Table_array: the range or boundary of your table (excluding headings) Col_index_num: the row number in your range that contains the corresponding data: range_lookup: True - finds the exact match or the next lower value in your table array. False - finds an exact match in your table array. Finds an exact match in your table array or finds the lowest value without going over. Beginning value in table array must be the lowest value of a lookup value. Finds the exact match in your table array. Returns a value you specify if a formula evaluates to an error, otherwise it returns the result of the formula.