I was so happy when MS finally put the SWITCH function in.
I would usually have a sheet full of tables ListObjects that stored this kind of information and then use a combination of =IFERROR() and =VLOOKUP() to match this data. I find it easier to add, edit and delete the information in the future without fiddling within a function.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I was so happy when MS finally put the
SWITCH
function in.I would usually have a sheet full of tables
ListObjects
that stored this kind of information and then use a combination of=IFERROR()
and=VLOOKUP()
to match this data. I find it easier to add, edit and delete the information in the future without fiddling within a function.