Selasa, 12 Juli 2016

[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: Taurean KV <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

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