Difference between sum of and v look up

Question

Accepted Answer

SUM function adds up values in a range while VLOOKUP function searches for a specific value in a table and returns a corresponding value.

SUM function is used to add up values in a range of cells.
VLOOKUP function is used to search for a specific value in the first column of a table and return a corresponding value from a specified column.
SUM function is a mathematical function while VLOOKUP is a lookup function.
SUM function is used for numerical data while VLOOKUP is used for text or alphanumeric data.
SUM function is used to calculate totals while VLOOKUP is used to retrieve specific information.
Example of SUM function: =SUM(A1:A5)
Example of VLOOKUP function: =VLOOKUP(A1, B1:C5, 2, FALSE)

Popular interview questions of Article and Audit Assistant