Advanced Excel Functions

What’s inside

• Which XLOOKUP formula returns the value from column C for the first exact match of the value in E2 within column A?
• Which formula sums values in D2:D100 when the corresponding region in B2:B100 is "West" and the corresponding sales…
• Which formula returns a spill range containing unique, nonblank values from A2:A100 sorted in ascending order?
• What does the following formula return when A2 contains 0: =IFERROR(B2/A2,"N/A")?
• Match each Excel function with its primary purpose.
• Match each lookup technique with the situation it best addresses.
• Match each function with the correct behavior when its main condition is not met.
• Match each dynamic-array function with its primary output.