+ Reply to Thread
Results 1 to 4 of 4

lookup values in a range,return corresponding column heading

  1. #1
    Registered User
    Join Date
    06-11-2011
    Location
    london england
    MS-Off Ver
    Excel 2007
    Posts
    1

    lookup values in a range,return corresponding column heading

    Hi all,
    I wud appreciate ur assistance in getting a macro script or nested function in excel that wud lookup values in a range and return the corresponding column header value that contains the matching value:

    ... A B C D E
    1 ore big red gel gin
    2 abc acb def lek sjd
    3 def sdf thr odh dfg
    4 ijk abc iod wfd opq
    5 lmn sef per wie dfk
    6 opq sef jgh ijk djf

    the formula will search for A2(abc) in the range,B2:E6 and return "big" since "abc" falls under B column header"big",so for A3(def),red(column header) wud be returned.


    Thanks

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: lookup values in a range,return corresponding column heading

    Wud is not a word. Where would you like the corresponding column headers returned to? Would you like to have a message box pop up for each one? Do you want sheet 2 to have a list of Sheet 1 column A values with the corresponding column headers in column B respectively?

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: lookup values in a range,return corresponding column heading

    I guessed that you would want it on another sheet. Sheet 2 in this example:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-11-2011
    Location
    College Station, Texas
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    42

    Re: lookup values in a range,return corresponding column heading

    Hi aljaffa,

    Please find the file attached in this post. Enter the word you would like to be looked up and hit the "lookup" button to get your result. Please let me know this is what you wanted

    Regards,
    Abi
    Attached Files Attached Files
    Abi

+ 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