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
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Count the highest number of days without “errors” 2
Can a formula do this? 1
Excel does not accept text format! 0
Check for values in column A and if found then column B must have value. 3

Top