CSE 2111 Lecture 9: CSE 2.14.17

• School: Ohio State University
• Department: Computer Science & Engineering
• Course: CSE 2111
• Professor: Clair Farris

Document Summary

Finds an entry from a vertical array based on some criteria. =vlookup(lookup_value, table_array, col_index_num, range_lookup: lookup_value: criteria to lookup or match, table_array: the range or boundary of your table (excluding headings). Rightmost column should contain the value: col_index_num: the column number in your range that contains the corresponding data, range_lookup: False: finds the exact match in your table array. Finds an entry from a horizontal array based on some criteria. =hlookup(lookup_value, table_array, row_index_num, range_lookup: lookup_value: criteria to lookup or match, table_array: the range or boundary of your table (excluding headings). Leftmost column should contain the table range. Rightmost column should contain the value: row_index_num: the column 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. Returns a value you specify if a formula evaluates to an error, otherwise it returns the result of the formula.