Difference between sum and look up

Question

Accepted Answer

Sum adds up values in a range while lookup retrieves a specific value from a table based on a given criteria.

Sum is used to calculate the total of a range of values.
Lookup is used to retrieve a specific value from a table based on a given criteria.
Sum can be used with multiple ranges of values.
Lookup can be used to search for a value in a table and return a corresponding value from another column.
Example: Sum(A1:A5) will add up the values in cells A1 to A5.
Example: Lookup('Product', 'Price', 'Product Name', 'Apples') will search for 'Apples' in the 'Product Name' column and return the corresponding value in the 'Price' column.

Top Wipro Anaplan Model Builder interview questions & answers