+ Reply to Thread
Results 1 to 4 of 4

Formula to return column title based on a cell reference

Hybrid View

AJB611 Formula to return column... 03-03-2017, 09:52 AM
kev_ Re: Formula to return column... 03-03-2017, 10:29 AM
AJB611 Re: Formula to return column... 03-03-2017, 11:51 AM
kev_ Re: Formula to return column... 03-03-2017, 11:59 AM
  1. 03-03-2017, 09:52 AM #1
    AJB611 is offline
    Registered User
    Join Date
    12-12-2016
    Location
    London, England
    MS-Off Ver
    2013 Professional
    Posts
    28

    Formula to return column title based on a cell reference

    I have a list of cell references pulled by VBA, and have managed to look up the row titles of the spreadsheet from it (just stripped out the letters), but can't find a way to use them to look up the column titles. I assume it can be done with formulas, any ideas? Thanks!
    Reply With QuoteRegister To Reply
  2. 03-03-2017, 10:29 AM #2
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Formula to return column title based on a cell reference

    with column titles in row1 and cell reference in column A

    Formula: copy to clipboard 
    =OFFSET($A$1,0,COLUMN(INDIRECT(A3))-1)


    ColumnTitles.jpg
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear
    Reply With QuoteRegister To Reply
  3. 03-03-2017, 11:51 AM #3
    AJB611 is offline
    Registered User
    Join Date
    12-12-2016
    Location
    London, England
    MS-Off Ver
    2013 Professional
    Posts
    28

    Re: Formula to return column title based on a cell reference

    Fantastic, works beautifully. Thanks very much!
    Reply With QuoteRegister To Reply
  4. 03-03-2017, 11:59 AM #4
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Formula to return column title based on a cell reference

    You are welcome
    thanks for marking the thread as solved
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to return cell value based upon cell reference
    By cyaeger in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-11-2016, 03:43 PM
  2. [SOLVED] Return column title based on smallest value by row?
    By realrookie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-29-2015, 12:58 PM
  3. [SOLVED] Reference a variable cell in a SUM formula based on values in a different column
    By sshot1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-17-2013, 12:40 PM
  4. [SOLVED] Formula to return (where available) multiple values based on reference cell
    By galvinpaddy in forum Excel General
    Replies: 3
    Last Post: 05-09-2012, 06:22 PM
  5. VB Scrip Help - IF CELL EQUALS VALUE THAN RETURN VALUE FROM COLUMN WITH SAME TITLE
    By cver in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2012, 11:33 AM
  6. Insert a formula with relative cell reference based on a number in a column
    By Dcritelli in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-16-2007, 05:54 PM
  7. [SOLVED] formula to return the value of a cell based on a looked up true reference
    By sarah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1