+ Reply to Thread
Results 1 to 6 of 6

Search field to lookup all information in database

  1. #1
    Registered User
    Join Date
    01-18-2016
    Location
    Belgium
    MS-Off Ver
    2011
    Posts
    3

    Search field to lookup all information in database

    Hello!
    My name is Carlo, i'm from Belgium and want to apologize in advance for probably making some spelling/grammar mistakes
    I'm new to this forum and registered because I wanted to ask for help. Me and my cousin are trying out a project regarding a game that we play. I made a database in Excel with all the information required but now I want to make a search field on another page where I can type in de nickname of the player. When you search this nickname, I want all the information regarding that player to show up. Is this at all possible? If yes, please help me to figure out how! If not, is there another way to simple do something like this?

    Thanks!

    XPL.xlsx (Hopefully this attachment works :D)

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Search field to lookup all information in database

    on lookup sheet A1 type John or doe
    In B1 copy paste below and drag to right
    =VLOOKUP("*"&A1&"*",Database!$B$2:$L$100,COLUMN(A1),0)

    apply desired formatting
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Registered User
    Join Date
    01-18-2016
    Location
    Belgium
    MS-Off Ver
    2011
    Posts
    3

    Re: Search field to lookup all information in database

    Thanks for your reply!

    This works, but it only finds the Name and Age values. All the other ones are error...
    onlyage.png

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Search field to lookup all information in database

    Looks like hemesh left off the absoluting...
    =VLOOKUP("*"&$A1&"*",Database!$B$2:$L$100,COLUMN(A1),0)

    Otherwise it works well
    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

  5. #5
    Registered User
    Join Date
    01-18-2016
    Location
    Belgium
    MS-Off Ver
    2011
    Posts
    3

    Re: Search field to lookup all information in database

    Yes that works! Thank you so much for the help

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Search field to lookup all information in database

    Glad it worked for you, thanks for the feedback

+ 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. Link information Database
    By 123needhelp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-05-2013, 03:51 AM
  2. Search Through Database And Display Results In Userform without showing database
    By nirvanarapeme in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2012, 05:18 PM
  3. Replies: 9
    Last Post: 05-22-2012, 08:59 AM
  4. Using ADO in Excel VBA - Search for Field in Access Database
    By JStoops in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2010, 04:46 PM
  5. Using ADO in Excel VBA-Search for Field in Access Database
    By JStoops in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2010, 04:11 AM
  6. How to auto update a field when the database field changes
    By hari_sudhan in forum Excel General
    Replies: 0
    Last Post: 03-20-2009, 07:15 AM
  7. [SOLVED] how do I set up a database for client information
    By Insurance Tracie in forum Excel General
    Replies: 1
    Last Post: 05-13-2005, 01:06 PM
  8. [SOLVED] Database Information
    By Nick in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-07-2005, 11:06 AM

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