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

Hi
use a lookup table together with VLOOKUP

--
Regards
Frank Kabel
Frankfurt, Germany

Beema wrote:
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