Spreadsheet Lookups: XLOOKUP and Data Matching

Spreadsheet Lookups: XLOOKUP and Data Matching

Answer 15 questions randomly selected from a bank of 40. Choose one best answer per question. Pass with 12 correct answers. Original professional practice, not an official certification exam.
1 of 15
A lookup key appears three times and the goal is to total all matching sales. Which function is more suitable than a single-result lookup?