Selasa, 12 Juli 2016

Re: [ExcelVBA] Formula to return column number


You can get the column number into a formula using the Column() function.
However, your requirement seems to be more complex than that   The Match() function will look up a value in a range of cells and return the number of the find in the range.  If your range starts at column A and is only in one row, then this would equate to the column number.

Regards, Dave S
----- Original Message -----
Sent: Wednesday, July 13, 2016 1:12 AM
Subject: [ExcelVBA] Formula to return column number

Morning everyone,

I need your advice. Is there a way to have a column number returned through a formula?

For example: I have sheet1 and sheet2. Sheet1 have data represented vertically with Cell A1, B1, C1 so on have the names like Tranche, Category, Pricing, and so on..

Sheet2 have names Tranche, Category, Pricing in cell A1, A2 & A3. I want cell B1, B2 & B3 to show the column number where aforementioned names are appearing in Sheet1.

Thanks in advance for your help!

Thank you,


Posted by: "David Smart" <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar