+ Reply to Thread
Results 1 to 5 of 5

Find specific value in table and return header row and header column value

  1. #1
    Registered User
    Join Date
    11-03-2013
    Location
    indonesia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Find specific value in table and return header row and header column value

    Dear all,

    Hi, my name is nelwan. I have a problem in excel, I want to find each data in a table cells and return
    appropriate row header name and column header name. I attached file in this forum,and i hope you are give me solution.
    Thank'scase1.xls

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Find specific value in table and return header row and header column value

    Like so.... (see attached).

    I removed the blank rows at the top to make the formulas a little easier to read.
    This only works for UNIQUE values in the table. Duplicates would not be discovered.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Find specific value in table and return header row and header column value

    Hi nelwan

    Welcome to the Forum!!

    This Code in the attached seems to do as you require
    Please Login or Register  to view this content.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    11-03-2013
    Location
    indonesia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Thumbs up Re: Find specific value in table and return header row and header column value

    Many thanks for your responses. JBeaucaire, this is a simple form i made in attachment file, actually i am working with
    many value and some value have duplicate name in table so, i don't think to replace any name in cells to convert to unique
    value as you said.

    I think answere from Jaslake suitable for what i'm find for. I have tested in complex excel form like mine and
    this vba code is working like what i mean. Thank's Jaslake for your solution.

  5. #5
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Find specific value in table and return header row and header column value

    You're welcome...glad I could help. Thanks for the Rep.

+ 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] Extract the column header given the row header and highest value in a subset of a table
    By pguarino in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2013, 02:05 AM
  2. [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
  3. Replies: 2
    Last Post: 01-31-2012, 11:35 PM
  4. Find a value and return value of the row and column header
    By JG2011 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-31-2011, 03:48 AM
  5. Find data in table but return HEADER
    By Greymalkin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2008, 01:32 PM

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