One way ..

Put in B1:
=IF(A1="","",VLOOKUP(A1,{"A","ACTIVE";"D","DELETED ";"C","CLOSED"},2,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GregNga" wrote:
I want to do something similar to CASE in SQL. That is if cell A1 is 'A' then
I went 'ACTIVE' in B1. if cell A1 is 'D' then I went 'DELETED' in B1. if cell
A1 is 'C' then I went 'CLOSED' in B1.

How to do this?