Results 1 to 3 of 3

Find cell in array that contains partial text and use column # of cell to lookup value

Threaded View

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    13

    Find cell in array that contains partial text and use column # of cell to lookup value

    Hi, I have data with headers over the columns. There are cells in the data which contain an asterisk (*) and I would like to find all of these cells and return the headers of the columns which contains those cells.

    Please reference sample.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] I need you!: Can I find/match cell in column then paste partial row?
    By CastingDirector in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-07-2015, 03:47 PM
  2. [SOLVED] Find Partial text in an array and extract charaters to right
    By jenita.kurlawala in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-02-2013, 08:03 AM
  3. Replies: 4
    Last Post: 07-27-2013, 07:38 AM
  4. [SOLVED] Help using VBA to highlight a partial column based on text in a cell out of the range
    By JTKEXCEL in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-20-2013, 04:46 AM
  5. [SOLVED] Find partial text in cell and assign variable a value if found
    By lday75 in forum Excel General
    Replies: 4
    Last Post: 07-26-2012, 01:36 PM
  6. Make new column using partial text in another cell
    By lmrippey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2005, 10:15 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