Hello all, I need help with a formula that will put a certain message in a cell depending on the first 4 digits of what is in another cell.
Example, cell A1 has 636755747857 the first 4 digits are 6367 so put "Blue" in cell B1.
There are about 20 combinations of the first 4 digits that will be unique so this is a shortened list. Thank You..
636755747857 Blue
636287561396 Yellow
636869685747 Green
636755747873 Blue
636287561324 Yellow
636869685740 Green
636755747865 Blue
636287561432 Yellow
636869685754 Green
636755747881 Blue
636287561360 Yellow
636869685733 Green
Example, cell A1 has 636755747857 the first 4 digits are 6367 so put "Blue" in cell B1.
There are about 20 combinations of the first 4 digits that will be unique so this is a shortened list. Thank You..
636755747857 Blue
636287561396 Yellow
636869685747 Green
636755747873 Blue
636287561324 Yellow
636869685740 Green
636755747865 Blue
636287561432 Yellow
636869685754 Green
636755747881 Blue
636287561360 Yellow
636869685733 Green