need the column number of a value

[zpierucci]

I am using an inputbox to have a user enter a month( Jan - Dec) The months are in Columns B:M in row 1

I need to know the column number of the selected month. I've tried match and it seems to be failing me. any ideas?

 

[kweaver]

If the input results in A1, then A2 would give you the month match and the column number: =MATCH(A1,B1:M1,0)+1

Another way could be: =MONTH(1&LEFT(A1,3))+1

Or simply: =MONTH(1&A1)+1

Is that what you mean?

 

[DanteAmor]

Try this

Sub enter_month()
  Dim mnt, n
  mnt = InputBox("enter a month( Jan - Dec)")
  n = Month(Format(("1/" & mnt & "/2019"), "dd/mm/yyyy"))
  msgbox "Column " & n +1
End Sub