+ Reply to Thread
Results 1 to 9 of 9

Retrieving information

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    10

    Retrieving information

    Hi to all,

    i have workbook in which I have two sheets, one of them cotains colums with information and in the other sheet I have to create a Search box to retrieve all from any Contact number, of course it has to be based on contact numbers culumn.

    example:

    CONTACT_NUMBER OPPORTUNITY_TYPE QUARTER CON_TYPE CONTRACT_TYPE_DESCRIPTION_LINE CURR_CODE
    379159 OUTSOURCE 201002 C4P SMARTnet Onsite Premium 2x7x4 USD
    389859 OUTSOURCE 201002 SNT SMARTnet 85xNBD USD
    379159 OUTSOURCE 201002 C4P SMARTnet Osite Premium 4x7x4 USD
    388859 OUTSOURCE 201002 SNT SMARTnet 85xNBD USD
    388459 OUTSOURCE 201002 SNT SMARTnet 85xNBD USD
    388459 OUTSOURCE 201002 SNT SMARTnet 85xNBD USD

    and in the other sheet I have to create a search box template that based on the contact number it will retrieve all other information. Can any one helpme?
    Last edited by facuse; 12-03-2009 at 01:32 PM.

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

    Re: Retrieving information

    I use INDEX/MATCH for this, but you can also use VLOOKUP() or LOOKUP() based on some other restrictions about the layout of the table you're searching. INDEX/MATCH has none of those restrictions.

    Here's some sample sheets showing exactly what you're looking to do.
    INDEX-MATCH-Simple.xls

  3. #3
    Registered User
    Join Date
    11-11-2009
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Retrieving information

    Thnkz, but I will need to do like a search box and once I type in any Contact number that could be fount in Sheet2, then it should return all columns that belong to that specific Countact number. I believe it should be done in VB.

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

    Re: Retrieving information

    Try this:
    Please Login or Register  to view this content.
    Right-click on the Sheet2 tab and select VIEW CODE
    Paste in the macro above
    Press Alt-Q to close the editor and save your sheet.

    Now type anything in cell A1 on sheet2 and it will retrieve all the data matching that number from Sheet1.

  5. #5
    Registered User
    Join Date
    11-11-2009
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Retrieving information

    I have the same contact more than once and I need to retrieve all those of the same contact with all other information that shows others colunms does any one knows how to do it please?

  6. #6
    Registered User
    Join Date
    11-11-2009
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Retrieving information

    sorry I didnt see your post :S my bad.. I will try it
    Thank You

  7. #7
    Registered User
    Join Date
    11-11-2009
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Retrieving information

    It worked!!!!!!!!!!!!!!!!!!!!! I really really appreciate it!!! thankz man...

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

    Re: Retrieving information

    If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


    (Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

  9. #9
    Registered User
    Join Date
    11-11-2009
    Location
    Argentina
    MS-Off Ver
    Excel 2007
    Posts
    10

    [SOLVED] Retrieving information

    Yes the issue was resolved. Thank you I will do the changes to this post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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