+ Reply to Thread
Results 1 to 8 of 8

Vlookup return the header name of table (Table of 4 column x 55 rows)

  1. #1
    Registered User
    Join Date
    01-09-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Vlookup return the header name of table (Table of 4 column x 55 rows)

    Hi,

    I am looking for a solution where the end result would be Column Header name.

    I have tried using vlookup but not working as expected. I want to search any record from 220 values and formula should return the header name of matched value position.

    My Table matrix is 4 column x 55 Rows.

    Thanks,

    San

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,844

    Re: Vlookup return the header name of table (Table of 4 column x 55 rows)

    Try uploading a sample workbook of your data, minus any confidential data. Include what you want to lookup, and the expected result.

    - Moo

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: Vlookup return the header name of table (Table of 4 column x 55 rows)

    you may have to do a seperate search in each column, and then use that result to give the header
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    01-09-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Vlookup return the header name of table (Table of 4 column x 55 rows)

    Thanks for Reply.

    PFA attached sample Excel.

    Thanks
    Attached Files Attached Files

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: Vlookup return the header name of table (Table of 4 column x 55 rows)

    Is that just random data you entered, or does your data follow that sequence (col1 = 100-199, col2 = 200-299, etc)?

  6. #6
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Vlookup return the header name of table (Table of 4 column x 55 rows)

    Hi sanpat

    Is the value you need to lookup in H14:H17! Whats the Values in H5:H8 with the word lookup in cell I5.
    See the attached file, cells J14:J17 are returning the column names for the criteria in H14:H17
    Attached Files Attached Files
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  7. #7
    Registered User
    Join Date
    01-09-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Vlookup return the header name of table (Table of 4 column x 55 rows)

    Hi,

    Its random data entered. But also my data doesn't follow any sequences (Its 8 digit numbers).

    As of now I have done some workaround by transpose data vertically (1 vertical column of 4 column) and put headers name against to recognise data by Vlookup.

    But this not looks good practice every time. Waiting for your revert. Thanks.

  8. #8
    Registered User
    Join Date
    01-09-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Vlookup return the header name of table (Table of 4 column x 55 rows)

    Hi Kevin,

    Yes, Your logic is correct this is what actually was looking for. Thanks for your Help.

    Thanks to forum group and individual one who has reverted on my query.

+ 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