+ Reply to Thread
Results 1 to 5 of 5

Find specific cell and return column number from a dynamic range

  1. #1
    Registered User
    Join Date
    10-11-2012
    Location
    switzerland
    MS-Off Ver
    Excel 2010
    Posts
    38

    Find specific cell and return column number from a dynamic range

    Hello everyone

    I don't know wheter it's me but I am incapable of finding anything on the internet that can do this:

    - I have a row that varies in length (between 100 and 200)

    - I want to find a text in that row, like "Text"

    - If a match occurs, I want to get the column number, like 5 and the column letter, like "E"

    So far I tried this:

    Please Login or Register  to view this content.
    It does not work, apparently I cannot use .column? Any help would be appreciated.
    Thanky you

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,612

    Re: Find specific cell and return column number from a dynamic range

    You can use Column if Text is found.

    Instead of Find why not try using Match?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Find specific cell and return column number from a dynamic range

    This UDF might help
    Please Login or Register  to view this content.
    If you want the column letter(s) change this line
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Enter the text to find in B1, and the row number in D1

    The result is in F1
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See the attached.
    Attached Files Attached Files
    Last edited by Marcol; 11-18-2012 at 11:27 AM.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Find specific cell and return column number from a dynamic range

    This might be more useful
    Please Login or Register  to view this content.
    To Return Letter(s)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    To return Number
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-11-2012
    Location
    switzerland
    MS-Off Ver
    Excel 2010
    Posts
    38

    Re: Find specific cell and return column number from a dynamic range

    Thank you all guys

    I ended up using this:

    Please Login or Register  to view this content.
    Great forum, really :D :D :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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