A. To perform a vertical lookup and return a value based on a specified criteria.
B. To perform a horizontal lookup and return a value based on a specified criteria.
C. To add up a range of cells.
D. To find the average of a range of cells.
A. To perform a vertical lookup and return a value based on a specified criteria.
B. To perform a horizontal lookup and return a value based on a specified criteria.
C. To add up a range of cells.
D. To find the average of a range of cells.