ExcelBanter - check the value in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - check the value in cell (https://www.excelbanter.com/excel-programming/448215-check-value-cell.html)

Marin[_2_]

check the value in cell

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 !

Ben McClave

check the value in cell

Hello,

Try this formula in cell B2:

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

All times are GMT +1. The time now is 09:30 AM.