Hi,

Am Tue, 19 Feb 2013 03:56:27 -0800 (PST) schrieb Marin:

I do not know how to solve a problem with excel. I want to check the value in cell 'A2' (3010-401/15/2013). if 'A2' has 3010 then in 'B2' should be 'street', if it has 3011, should then be 'block', if the 3012, it should be a 'town'

try:
=CHOOSE(LEFT(A2,4)-3009,"Street","Block","Town")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2