+ Reply to Thread
Results 1 to 13 of 13

Searching three titels to get result

  1. #1
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Searching three titels to get result

    Hi

    I want to be able to search three titles to get the corresponding result to those three titles.

    As seen in the attachment if I wanted to search for Dog, Big, B the answer would be 6 or if I wanted to search cat, medium, A the answer would be 8

    Three search.xlsx

    Thanks

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Searching three titels to get result

    With an pivot table.

    See the attached file.

    I wasn't able to upload a file yet.

    I try it later.

    I tried it again but no succes. 13.25 hour
    Last edited by oeldere; 07-07-2014 at 07:25 AM.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Searching three titels to get result

    See the attachment
    Attached Files Attached Files
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: Searching three titels to get result

    How about if what I was looking for was in one cell that read Dog Big B for a result of 6 or Fish Medium A for a result of 1?

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Searching three titels to get result

    Just Change the name in Cell "G3","H3" and "I3" as per your requirement

  6. #6
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: Searching three titels to get result

    I want to be able to search when the names are combined, not in three different cells. so in cell G3 the name will be "Dog Big B".

    Any ideas?

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Searching three titels to get result

    See the attached file with an pivot table.
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: Searching three titels to get result

    Thanks but the pivot table doesn't fit what I am trying to do, see the post above, I am trying to get a result with all three names are combined in one cell.

  9. #9
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Searching three titels to get result

    =MAX(INDEX(($B$3:$B$12&" "&$C$3:$C$12&" "&$D$3:$D$12="DOG BIG B")*($E$3:$E$12),0))
    Try this formula

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Searching three titels to get result

    In that case you can amend the criteria in the pivot table.

    I bet the pivot table will suit your needs.

  11. #11
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: Searching three titels to get result

    That works, now for the final part of the equation. See the attachment I have taken out a few of the types so there is blanks (cell b5, b7 & b11) when these cells are blank I want the formula to take the cell to the left and consider that in the equation. So now the result im looking for is "2 Big B" with the answer being 12


    Four search.xlsx.

  12. #12
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Searching three titels to get result

    see the attached file
    Attached Files Attached Files

  13. #13
    Forum Contributor
    Join Date
    03-19-2014
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    101

    Re: Searching three titels to get result

    Seems to be close

    The equation needs to look at column B and if it is full use it but if it is empty use the column A that is side by side with the empty column B, this is the only time column A should be used.

    Five search.xlsx

+ 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. Searching in a list, display the result in combo box
    By khellen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2013, 07:38 AM
  2. Searching Other Sheets in Workbook for a Result
    By MCoster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2013, 12:30 PM
  3. Searching Text Result & Filter
    By feinberg1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2011, 02:21 PM
  4. Searching with Excel Macro & Displaying Result
    By Smurlos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2009, 09:08 AM
  5. Searching and displaying the result using VBA
    By kevinhd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2005, 04:12 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