check the value in cell

  • Thread starter Thread starter Marin
  • Start date Start date
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 !
 
Hello,

Try this formula in cell B2:

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