+ Reply to Thread
Results 1 to 8 of 8

multiple search terms (sorry if in wrong subforum)

  1. 09-18-2012, 11:36 AM #1
    meneses
    meneses is offline
    Registered User
    Join Date
    09-18-2012
    Location
    no
    MS-Off Ver
    Excel 2010
    Posts
    15

    multiple search terms (sorry if in wrong subforum)

    i just started an inernship at a company, my main task during this internship is to create a database in excell of hotels.

    ì'm not sure if this is already built in or not but i figured i'd ask before i start.

    i need the ppl using my database to for example type in search box "amsterdam 3 star" and the result only come up with the rows ((?) horizontal ) that have both search terms in it.

    if excel already does this then mods please delete my topic if not please help me out by tellign me what to do, i have not used excell in a few years been mostly using SPSS due to uni stuff.
    Last edited by meneses; 09-18-2012 at 12:00 PM.
    Reply With QuoteRegister To Reply
  2. 09-18-2012, 11:58 AM #2
    meneses
    meneses is offline
    Registered User
    Join Date
    09-18-2012
    Location
    no
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: multiple search terms (sorry if in wrong subforum)

    in essence i need same type of thng as this guy, but i don't understand the 2 replies also i am a much bigger excel noob
    http://www.excelforum.com/excel-prog...ugh-excel.html
    Reply With QuoteRegister To Reply
  3. 09-18-2012, 12:23 PM #3
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: multiple search terms (sorry if in wrong subforum)

    See if something like this, helps you.
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  4. 09-18-2012, 12:32 PM #4
    meneses
    meneses is offline
    Registered User
    Join Date
    09-18-2012
    Location
    no
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: multiple search terms (sorry if in wrong subforum)

    Quote Originally Posted by Fotis1991 View Post
    See if something like this, helps you.
    it does seem to do exactly what i want how would i go setting it up for multiple variable searches? my example was just over simplified i will have 10 variables or so id liek whoever uses it to search out any of the variables in same way.
    Reply With QuoteRegister To Reply
  5. 09-18-2012, 01:52 PM #5
    meneses
    meneses is offline
    Registered User
    Join Date
    09-18-2012
    Location
    no
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: multiple search terms (sorry if in wrong subforum)

    anyone know what fotis 1991 did? and if so can you maybe tell me the input of the macro / formula? i want to be able to see it in code in order to figure out what i need to edit in order to set it up for all the variables i will be putting in
    Reply With QuoteRegister To Reply
  6. 09-18-2012, 04:42 PM #6
    meneses
    meneses is offline
    Registered User
    Join Date
    09-18-2012
    Location
    no
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: multiple search terms (sorry if in wrong subforum)

    bumping this up with further detail

    below is attached excell table variables. have not filled in any of the columns yet just started lookign up the info ill be filling.
    i need to know how to set up simialr search function as previopus guy a did but with all the columns not just 2

    EDIT: please either code or shwo me step by step what to do i`d liek to actualyl know how its done


    Libro1.xlsx
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 09-19-2012, 11:20 AM #7
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: multiple search terms (sorry if in wrong subforum)

    First you have to create 2 lists. 1 for Towns and 1 for the stars and give a name to eatch one, if you like.

    Then in Sheet1 you put your data. As many rows as many columns you like.

    In Sheet2, find the 2 criteria from the drop down list.

    In A2, put this formula and drag down and acaross, as mutch as you want.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 09-19-2012, 11:21 AM #8
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: multiple search terms (sorry if in wrong subforum)

    A new example.....
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1