+ Reply to Thread
Results 1 to 3 of 3

Column letter in formula dependent on another cell question

  1. #1
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2021
    Posts
    974

    Column letter in formula dependent on another cell question

    Hello Group:

    Is it possible to take this array formula:
    Please Login or Register  to view this content.
    and amend it so that the red column letters in this formula would be dependent on a letters in cells FM1 and FQ1? So for instance if cell FM1 had the letter "P" displayed in it, the "Q" in my formula above would automatically change to "P" and if cell FQ1 had the letters "AA" in it, the "AD" in my formula would change to reflect the letters in "AA" as specified in cell FQ1, etc. The quotation marks are not needed in the formula. I would be very grateful for any feedback, even if it's to say it can't be done. Every year I have to manually edit hundreds of formulas to reflect the new column letters, so I'm trying to figure out a way to avoid doing that, by this approach.

    Thanks in advance!
    Last edited by lilsnoop; 02-25-2015 at 07:32 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: Column letter in formula dependent on another cell question

    Try to replace this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    in your formula, become to
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    It may help for yr problem
    Best regard, -)iger-/iger
    If you are pleased with a solution mark your post SOLVED.

  3. #3
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2021
    Posts
    974

    Re: Column letter in formula dependent on another cell question

    Thank you so much!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Chage column letter in the formula based on cell value.
    By JuauM in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-12-2015, 10:48 AM
  2. [SOLVED] How to change the column letter in a cell formula from another cell
    By Freakazoid in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-30-2012, 06:50 AM
  3. a formula to get a cell column letter based on a number
    By luv2glyd in forum Excel General
    Replies: 2
    Last Post: 06-03-2011, 02:52 PM
  4. Newbie question: change column heading back to letter
    By dredwin in forum Excel General
    Replies: 1
    Last Post: 01-19-2010, 09:23 PM
  5. Formula to return column heading dependent on number in cell
    By Reidm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2008, 05:04 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1