Hello,

In a particular range of cells I have a drop down list that allows me to
pick from the following: 1b14, 1a14, 2a15, 2a15, 3a14,3b15, P1, P2, P3, P4

I have the forlmula that states if data starts with a number then return a
certain cell.

how would I write, If in range b1:c:4, the data's second character is a
number then return A1?
Thank You,
Brian