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

Similar Threads

Excel check value i cell 6
help with formula 4
Date match problem 2
Can a formula do this? 1
Count the highest number of days without “errors” 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Match Value and Show MsgBox 1

Top