+ Reply to Thread
Results 1 to 6 of 6

Return Column Number when specific text is found

  1. #1
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2013
    Posts
    108

    Return Column Number when specific text is found

    Hi All,

    I am looking for a formula to return the column number of the array when a specific text is found, in this case the text is "Yes"

    The Array will only ever be 5 cells beside each other in a row

    for example, M4:Q4, will be as follows - No No No Yes No

    I want a formula to look at these 5 cells and return the number 4 as that is where the "Yes" value is

    Any help greatly appreciated. been trying some lookup formulas but cant figure it out

    Simon

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,379

    Re: Return Column Number when specific text is found

    Use Match:
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2013
    Posts
    108

    Re: Return Column Number when specific text is found

    Perfect, Thanks very much, reputation added

    Simon

  4. #4
    Registered User
    Join Date
    05-06-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Return Column Number when specific text is found

    Give this a try:

    Please Login or Register  to view this content.

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,379

    Re: Return Column Number when specific text is found

    Just a comment to jumpingmaniac formula - third argument to Match function is important in most cases like the above one.
    Otherwise excel assumes that data in the range is sorted (which is not true).

  6. #6
    Registered User
    Join Date
    05-06-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Return Column Number when specific text is found

    Thanks for the tip!
    Last edited by jumpingmaniac; 04-29-2014 at 12:51 PM.

+ 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] Grab the number of x in column a if found in column b under a specific name
    By HNoel33 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2013, 01:56 PM
  2. [SOLVED] If specific text is found in cell, then return a number
    By csch123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2013, 05:07 PM
  3. [SOLVED] Locate column with specific title and delete rows if predefined set of text is found
    By johnny_tc in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-25-2012, 01:57 PM
  4. fastest way to find the row where a specific text is found in a specific column
    By getgray in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2011, 02:45 PM
  5. Search column - return row found in long text string
    By JayL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2005, 12:06 AM

Tags for this Thread

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