+ Reply to Thread
Results 1 to 9 of 9

multiple search criteria

  1. 10-19-2023, 03:58 PM #1
    Buckets of Ogeez
    Buckets of Ogeez is offline
    Registered User
    Join Date
    07-12-2021
    Location
    Barcelona
    MS-Off Ver
    Mac 2019
    Posts
    13

    multiple search criteria

    Good evening I hope someone can help me. Please seen the attachment 'excelent'
    I would like cell C13 in 'sheet y' to return the value found in another sheet called 'sheet x'.
    I want the value to be given that corresponds to the date in A10 (of sheet y) in 'sheet x' in column C.
    And then also corresponds to the value (product name) that is in cell C10 (of sheet y) and can be found column G of 'sheet x'.
    After that, the value must also correspond to the value found in A11 (of sheet y) and that value is found in column I of 'sheet x'. And if no value is found, the cell must remain empty.
    Thank you in advance for helping me...
    Cheerszzz,
    Bas
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-19-2023, 04:20 PM #2
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: multiple search criteria

    Which Ms-Off version do you have? There is no Ms-Off ver: 2020.

    You can check your current version in Excel: Click on your account name at the top (right) and click Office User Info.
    The 3 most recent versions are 2019, 2021 and 365
    Reply With QuoteRegister To Reply
  3. 10-20-2023, 01:43 AM #3
    Buckets of Ogeez
    Buckets of Ogeez is offline
    Registered User
    Join Date
    07-12-2021
    Location
    Barcelona
    MS-Off Ver
    Mac 2019
    Posts
    13

    Re: multiple search criteria

    It seems I have version 2019. sorry for the misunderstanding. Attached print screen of what I found.

    On the right top was nothing regarding the version I am using. Maybe because I am working on Mac.
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  4. 10-20-2023, 01:47 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,911

    Re: multiple search criteria

    Please change your profile to Excel 2019 for Mac. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 10-20-2023, 01:50 AM #5
    Buckets of Ogeez
    Buckets of Ogeez is offline
    Registered User
    Join Date
    07-12-2021
    Location
    Barcelona
    MS-Off Ver
    Mac 2019
    Posts
    13

    Re: multiple search criteria

    Ok, I will, thank you!
    Reply With QuoteRegister To Reply
  6. 10-20-2023, 02:33 AM #6
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: multiple search criteria

    Please try in C13 and copy to all other BATCH-cells:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 10-20-2023, 02:52 AM #7
    Buckets of Ogeez
    Buckets of Ogeez is offline
    Registered User
    Join Date
    07-12-2021
    Location
    Barcelona
    MS-Off Ver
    Mac 2019
    Posts
    13

    Re: multiple search criteria

    Wow! This is magic! I'll try to implement this my own file.
    Thank you very much! Will keep you updated
    Cheersz,
    Bas
    Reply With QuoteRegister To Reply
  8. 10-20-2023, 02:53 AM #8
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,911

    Re: multiple search criteria

    If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
    Reply With QuoteRegister To Reply
  9. 10-20-2023, 03:13 AM #9
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: multiple search criteria

    Dank je wel voor de feedback en rep. Graag gedaan. .
    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)

Similar Threads

  1. Looking for a more dynamic SUMPRODUCT(ISNUM(SEARCH option for a lot of data.
    By Lacey87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-13-2022, 01:01 AM
  2. How to search sums of table, with multiple criteria AND less criteria than needed
    By HereComesTheBoom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2018, 02:42 PM
  3. Create User form to perform search using multiple search criteria
    By cherias in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 06:16 AM
  4. Create a search userform to search using multiple criteria
    By Aleemaher in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2014, 09:17 AM
  5. Creating Multiple search tool (currently single criteria search) and reporting to Main Pag
    By Gluv1983 in forum Excel General
    Replies: 4
    Last Post: 05-20-2014, 10:03 AM
  6. Search Multiple Worksheets Against List of Non-Exact Search Criteria?
    By thump4r in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2010, 03:46 PM
  7. How do I search excel spreadsheets using multiple search criteria.
    By Kasper in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-14-2005, 08:30 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1