Excel check value i cell

[Marin]

Dear Sirs,
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'

thanks in advance !

 

[Claus Busch]

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

 

[Marin]

Hi,



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






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''

 

[lhkittle]

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

 

[Marin]

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

 

[Claus Busch]

Hi Marin,

Am Wed, 20 Feb 2013 08:04:55 -0800 (PST) schrieb Marin:

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

it could be the separator. Change the commas to semikolons.
Does it work?


Regards
Claus Busch

 

[Marin]

Hi Marin,



Am Wed, 20 Feb 2013 08:04:55 -0800 (PST) schrieb Marin:







it could be the separator. Change the commas to semikolons.

Does it work?





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

yes!
thing is working
i import this:
=CHOOSE(LEFT(A2;4)-3009;"Street";"Block";"Town")

thx once again. iam so happy now