View Single Post
  #1   Report Post  
Beema
 
Posts: n/a
Default CASE statement equivalent

I need a function which does the following, but cannot find one:

[to be put in cell B2]

=(CASE A2
when "AAA" then "Some text"
when "BBB" then "Other Text"
else "")

Is anything, other than a bunch of nested IF statements, possible?

Thanks