+ Reply to Thread
Results 1 to 4 of 4

Return value in that column/row when value in that column matches column header in tab 1

  1. #1
    Registered User
    Join Date
    09-03-2013
    Location
    Elgin, IL
    MS-Off Ver
    Excel 2010
    Posts
    90

    Return value in that column/row when value in that column matches column header in tab 1

    I have a database of information I download into excel but the columns of data I download is not in my preferred order, so I'm trying to set up a excel file that has 2 tabs. Tab 1 has all the columns of data in my preferred order which I download from a program of mine, and Tab 2 has all of the same columns of data but in a different order.

    So both Tabs 1 and 2 will have all the same columns of information but in a different order/arrangement.

    I've attached a sample excel file. I need a formula that will go into the yellow highlighted cells in Tab 1 MASTER that will search the column header values in Tab 2, and when it finds a match of that name that's located in Row 1 of Tab 1 MASTER, it will return each of the values in that column into my Tab 1 MASTER.

    So basically, it's a formula that will automatically rearrange/sort the data in the order I prefer versus the order that the data is downloaded in.

    Thanks so much in advance for your help on this!!

    Be Well.
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Return value in that column/row when value in that column matches column header in tab

    Try this......

    Please Login or Register  to view this content.
    and then drag across and down.

    Is this what you want?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    09-03-2013
    Location
    Elgin, IL
    MS-Off Ver
    Excel 2010
    Posts
    90

    Re: Return value in that column/row when value in that column matches column header in tab

    Worked perfectly - thank you!!

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Return value in that column/row when value in that column matches column header in tab

    Glad to help you. Thanks for the feedback.
    If your query is resolved, please mark your thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

+ 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. Return column header based on column criteria and number value
    By bwill22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2014, 07:33 PM
  2. Replies: 1
    Last Post: 10-05-2013, 03:35 PM
  3. lookup formula to return data where column header matches
    By tim-harrison in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-06-2013, 12:58 AM
  4. Formula to find all matches in column A and return cells from column C
    By GenericPat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2012, 04:56 PM
  5. Return Value from 2nd column when value in 1st column matches given criteria
    By Russell_K in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2008, 12:07 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