COMPSCI 1BA3 Lecture Notes - Income Statement, Lookup Table

69 views3 pages

Document Summary

Lookup tables and functions in the table"s first column or row you are trying to find) needs to match the compare values. A table that organizes data you want to retrieve into different categories. The categories for the lookup table, called compare values, are located. To retrieve a particular value from the table, a lookup value (the value. Error values such as #div/0!, #n/a, and #value! indicate that some element. Using the lookup table to find an exact match. Using the lookup table to find an approximate match. Searches the first column of the table until it locates the largest value that. Allows you to change a cell"s formatting when its contents match a. The iferror function can determine if a cell contains an error value and. To highlight those cells whose values may warrant action. E. g. , duplicate records, negative balances, overdue dates. When would you use this? is less than the lookup value.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions