Get column number by entering a its name

[GerPis]

Hi everyone!

I have an excel file in which the first row containg the names of all the columns (Name, Adress, ZipCode...).

I need a code to input a name and get the number of the column that has that name. For example, if my first column is "Name", when in the imput box I write "Name" a certain integer, let's say column_num, will get the 1 value.

Any suggestion? Thank you in advance.

[zbor]

Try MATCH function:

=MATCH("name", A1:D1, 0)

For name you can put some reference like Sheet2!A1

[jraj1106]

Hi

You mean to say the row num or the col num?

[GerPis]

My input is the name of the column and my desired output is the number of the column that has the name that I have introduced. Zbor, I'll give your solution a try, thanks!

[GerPis]

That's what I have now:

Please Login or Register  to view this content.

I know the line where I use the MATCH function has a bad syntax, but I am a noob with VBA and I don't know how to solve it...

[zbor]

Try:

Please Login or Register  to view this content.

[jraj1106]

Try this.. I hope this is what you wanted..

GerPis.xlsm

[GerPis]

Jraj1106, your solution works but Zbvor's is faster. Thank you both for your ideas, I already could do what I needed.