need help in IF function

[katak101]

hi all, i need helps on my sheet.

im using a formula like "j2=COLUMN(INDIRECT(B2&1))" to change certain text into number. my problem is sometimes the column using number and sometimes it using text.

example:
b2 = 1 j2 = =COLUMN(INDIRECT(B2&1))
c2 = a j3 = =COLUMN(INDIRECT(c2&1))
d2 = 3 j4 = =COLUMN(INDIRECT(d2&1))
e2 = b j5 = =COLUMN(INDIRECT(e2&1))

in
b4 = j2
c4 = j3
d4 = j4
e4 = j5

some of it will return an error. the question is how can i using 'IF' function to select if it is a number then it will direct return to b4 but if it is an alphabet then it will choose to convert it to number. hope u guys understand what im trying to ask here.

[brokenbiscuits]

=if(isnumber(b2),b2,column(indirect(b2&1)))

[katak101]

wow..its works. Thanks a lot Mr brokenbiscuit for your helps. you are a lifesaver :D