CASE statement equivalent

[Beema]

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

 

[Frank Kabel]

Hi
use a lookup table together with VLOOKUP