One way, array-entered (CTRL-SHIFT-ENTER or CMD-RETURN):
=IF(OR(ISNUMBER(-MID(B1:C4,2,1))),A1,"")
In article ,
"Brian" wrote:
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
|