Which function will match multiple values and return the first match in Excel?
IF()
IFS()
IIF()
SWITCH()
Correct answer is D
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")