+ Reply to Thread
Results 1 to 7 of 7

how to extract data from different sheet using line number

  1. #1
    Registered User
    Join Date
    08-12-2014
    Location
    Algeria
    MS-Off Ver
    2007
    Posts
    21

    Post how to extract data from different sheet using line number

    so I am having a hard time extracting data from different sheet ...


    I want to type a number or the line & I get the info in the other sheet
    take a look at my excel file & u will get what I am trying to do :
    Attached Files Attached Files
    Last edited by zitno; 12-20-2014 at 02:07 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: how to extract data from different sheet using line number

    Couple things with your given setup I would type in A4

    Please Login or Register  to view this content.
    Being that you named A2 Criteria

    Then starting in B4
    Please Login or Register  to view this content.
    Now if you would add your Headers from the lookup sheet to the results sheet or OUTPUT then you could use this starting in A4
    Please Login or Register  to view this content.
    But again, that Index match requires that you put the headers in row 3 to match the headers from the index range row 1
    -If you think you are done, Start over - ELeGault

  3. #3
    Registered User
    Join Date
    08-12-2014
    Location
    Algeria
    MS-Off Ver
    2007
    Posts
    21

    Re: how to extract data from different sheet using line number

    yea :P ... well I am noob can u make it easier for me :P ...
    thanks for ur help

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: how to extract data from different sheet using line number

    Use this formula in A4 and pull it to the right

    =VLOOKUP(Criteria,'base de données'!$A$2:$F$6,COLUMNS($A:A),0)
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  5. #5
    Registered User
    Join Date
    08-12-2014
    Location
    Algeria
    MS-Off Ver
    2007
    Posts
    21

    Re: how to extract data from different sheet using line number

    guys I get err .. but I think it's bcuz I am suing french version of Excel

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

    Re: how to extract data from different sheet using line number

    I think there is a confusion to understand the requirement.
    On the Output sheet, you have entered 4 in A2 and you want the matching record on row 4. So if you enter 5 in A2, do you expect the row 5 to populate with the matching record? Or it is always row 4?

    BTW If you are open to a VBA solution, find the attached sheet and input a row number in A2 and the record will be populated in row 4. See if this helps.
    Attached Files Attached Files
    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.

  7. #7
    Registered User
    Join Date
    08-12-2014
    Location
    Algeria
    MS-Off Ver
    2007
    Posts
    21

    Re: how to extract data from different sheet using line number

    it works :D ... thank you guys so much ^_^

+ 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. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  2. Copy the data from 1 sheet in vertical line to another sheet in horizontal line
    By Shermaine2010 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2014, 03:46 AM
  3. Extract data in rows (with line breaks) to form a table
    By teireii in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2013, 09:49 PM
  4. [SOLVED] Extract data by line color?
    By g48dd in forum Excel General
    Replies: 6
    Last Post: 02-03-2011, 09:38 AM
  5. Replies: 3
    Last Post: 11-10-2008, 11:53 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