+ Reply to Thread
Results 1 to 7 of 7

How to Create a Search Function?

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    4

    How to Create a Search Function?

    Hey guys,

    So I'm sort of new to all this function creating business on Excel. Anyways, I have a sheet with Number, First Name, Last Name, Nickname, and Birthday. I need to create some sort of way to search for a specific name so that the sheet will jump to the row in question. If not that, then a pop up window that will say what row the input is in. Any ideas for how to go about this?

    Let me know!

    Thanks,

    Sara

    P.S. I'm using Excel 2011 for Mac

  2. #2
    Registered User
    Join Date
    04-19-2013
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: How to Create a Search Function?

    attach a sample workbook that helps to better explain what you are trying to accomplish and you will get better answers!

    are you familiar with Autofilters? select the table and under the 'Data' tab select 'Filter' and then you can toggle the dropdowns to filter down to exactly what you are looking for. depending on what exactly you are trying to do this may be easier than using formulas.

  3. #3
    Registered User
    Join Date
    05-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    4

    Re: How to Create a Search Function?

    Search Example.xlsx

    Example attached

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: How to Create a Search Function?

    Are you familiar with macro code? when a match is found, a message box will pop out to show you the cell address(location) of the found name. I do not even think it is possible to get an output in to message box

  5. #5
    Registered User
    Join Date
    04-19-2013
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: How to Create a Search Function?

    still learning macros myself...this is out of my league. i thought you were talking about the actual SEARCH formula within Excel.

    goodluck and godspeed

  6. #6
    Registered User
    Join Date
    05-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    4

    Re: How to Create a Search Function?

    I know what macro code is, but I don't know how to do it myself. I found another macro code that would fill in the cell, but it wouldn't tell me where it was, and then I had to manually un-fill it.

    You don't happen to know a generic macro code that would either scroll the page to the found cell or just have a pop-up that dictates where the cell is, do you? I'd really appreciate it!

  7. #7
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: How to Create a Search Function?

    Shendel,
    Yes, if you search, let say, for a name and this name is found, the macro will tell you where this name is found by a message box, but to do it, you need to tell me what/where you are searching for? You can also use input box as in put which means, the code asks you what do you want to search, for or you can put the search name in a cell.

+ 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