Results 1 to 18 of 18

Search cell for words in table and then return table header

Threaded View

  1. 05-01-2017, 04:39 PM #13
    leovfx
    leovfx is offline
    Registered User
    Join Date
    01-15-2017
    Location
    LONDON, ENGLAND
    MS-Off Ver
    Excel Mac 2011 14.6.6
    Posts
    55

    Re: Search cell for words in table and then return table header

    Hi,

    One last thing to make this perfect...

    Currently the search appears to be case sensitive. Is there a simple way to change it so that it isn't?

    Can I just change FIND to SEARCH or is there a special reason that you used FIND that I'm overlooking?
    Last edited by leovfx; 05-01-2017 at 04:44 PM.
    Reply With QuoteRegister To Reply
« 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. Formula to search table by row & get corresponding column header & intersecting cell.
    By dayala2002 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2017, 08:54 PM
  2. [SOLVED] search table for unique values, return value and corresponding cell to another sheet
    By thara95 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-06-2017, 09:47 AM
  3. [SOLVED] Pull out col. header from table based on two input parameters to search for in the table.
    By pcrewlok in forum Excel General
    Replies: 3
    Last Post: 08-13-2015, 10:07 PM
  4. [SOLVED] Find specific value in table and return header row and header column value
    By nelwan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2013, 01:35 AM
  5. [SOLVED] Return the column header for every value 'x' along each row in table
    By pcassidy in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-21-2013, 06:49 PM
  6. Vlookup return the header name of table (Table of 4 column x 55 rows)
    By sanpat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-09-2013, 11:23 PM
  7. [SOLVED] Search for a number in a table and return data of a specific cell
    By Karaman in forum Excel General
    Replies: 4
    Last Post: 06-30-2006, 10:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1