+ Reply to Thread
Results 1 to 4 of 4

Help needed, search in database and present result.

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    3

    Help needed, search in database and present result.

    Hey there! New member here and in serious need for some help.

    Let me first present what we got to work with here:

    1. We have quite a large database in one excel page with about 25000 rows, now each row got a unique six digit number in the first column, the rest of the row contains various info separated in the columns.

    2. What we would like to do for a start is to have a separate excel page with a "searchable cell" in this cell we would like to input any six digit number and this will start a search in the other document for the row that matches the input number. Now once found we would like to present that row in the searchable page.

    Is this possible to achieve in some easy steps or do we need some extra programming?..

    Kind regards!
    /Nicholas

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Help needed, search in database and present result.

    hi Nicholas, welcome to the forum. sounds like VLOOKUP can help you. do upload a sample Excel file for us to help you better. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon

    assuming your large database is in A1:G25000 of Sheet1, and the unique 6 digit in the other worksheet is in cell A1, it looks something like:
    =VLOOKUP(A1,Sheet1!$A$1:$G$25000,2,0)

    this is to look for the unique number in column A & return the 2nd column. just an eg

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    10-05-2012
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help needed, search in database and present result.

    Right on! Thanks for the quick reply, I think my test doc is attached now ...
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-05-2012
    Location
    Sverige
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Help needed, search in database and present result.

    Solved! Thank you so much for the help!..

+ 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