check the value in cell

M

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, than should be 'block', if is the 3012, it should be a 'town'

many thanks !
 
B

Ben McClave

Hello,

Try this formula in cell B2:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top