Home » MCQs » Microsoft Excel MCQs

Which function is used to match multiple values and returns the first match?

23. Which function is used to match multiple values and returns the first match?

1. IF()
2. IFS()
3. IIF()
4. SWITCH()

Answer: D) SWITCH()

Explanation:

The SWITCH() function is used to match multiple values and returns the first match.

Syntax:

=SWITCH (expression, val1/result1, [val2/result2], ..., [default])

Example:

=SWITCH(G4,0,"Sun",1,"Mon",2,"Tue",3,"Wed",4,"Thu",5,"Fri",6,"Sat")