On Wednesday, February 20, 2013 12:01:41 PM UTC+1, wrote:
On Tuesday, February 19, 2013 11:15:22 PM UTC-8, Marin wrote:

On Tuesday, February 19, 2013 1:48:52 PM UTC+1, Claus Busch wrote:



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







hmmm...



Excel sais : ''formula error''



I tried the formula Claus offered and this one by Ben in the .Programming forum.

Both worked for me, using Excel2010.



=CHOOSE(1+MID(A2, 4, 1), "street", "block", "town")



Howard

iam from Croatia, EU.
so maybe problem is cause regional setting... who knows

anyway, thank you guys so much