+ Reply to Thread
Results 1 to 15 of 15

How to use Index and Match to retrieve data but exlude some other data

  1. 06-02-2023, 11:35 AM #1
    VJo
    VJo is offline
    Registered User
    Join Date
    10-03-2022
    Location
    toronto
    MS-Off Ver
    MS365 Version 2304
    Posts
    12

    How to use Index and Match to retrieve data but exlude some other data

    Hello Everyone,

    I need help with the attached document. I want that the second tab (Fac Schedule) retrieves data from the first tab (Base Schedule) but distinguish between online and in class courses. The in person courses should be in separate columns and online courses in separate columns although in the original tab they are in the same columns. The classes in person have room numbers (101).
    Please find attached the document.

    Thank you in advance.
    Attached Files Attached Files
    Last edited by AliGW; 06-05-2023 at 04:02 PM. Reason: SOLVED tag applied - no need to edit the thread title!
    Reply With QuoteRegister To Reply
  2. 06-02-2023, 11:47 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,054

    Re: How to use Index and Match to retrieve data but exlude some other data

    Hi. Before we get going on this one...

    Is your forum profile showing the Excel PRODUCT that you need this request to work with? Win 10 is your Operating System, not your Excel Product.

    The best solutions often rely on knowing WHICH Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date. If you aren't sure, in Excel go to File/Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

    The three most recent Excel PRODUCTS are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the Version number in your profile (e.g. MS365 (PC) Version 2211). The version number is in the About Excel section further down the Account page.

    Cheers,

    Glenn.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 06-02-2023, 11:58 AM #3
    VJo
    VJo is offline
    Registered User
    Join Date
    10-03-2022
    Location
    toronto
    MS-Off Ver
    MS365 Version 2304
    Posts
    12

    Re: How to use Index and Match to retrieve data but exlude some other data

    Fix it.

    Thank you so much
    Reply With QuoteRegister To Reply
  4. 06-02-2023, 12:12 PM #4
    HansDouwe
    HansDouwe is online now
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: How to use Index and Match to retrieve data but exlude some other data

    Please add manually your epepected results on the second tab.
    Reply With QuoteRegister To Reply
  5. 06-02-2023, 12:21 PM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,054

    Re: How to use Index and Match to retrieve data but exlude some other data

    and tell us which sheet(s) we should be looking at!!

    Remember... you KNOW what you're looking at... we don't. Therefore you need to tell us where to look, or we get bored and move on...
    Reply With QuoteRegister To Reply
  6. 06-02-2023, 12:25 PM #6
    VJo
    VJo is offline
    Registered User
    Join Date
    10-03-2022
    Location
    toronto
    MS-Off Ver
    MS365 Version 2304
    Posts
    12

    Re: How to use Index and Match to retrieve data but exlude some other data

    Just uploaded an improved version.

    Hope it helps.
    Reply With QuoteRegister To Reply
  7. 06-02-2023, 12:26 PM #7
    VJo
    VJo is offline
    Registered User
    Join Date
    10-03-2022
    Location
    toronto
    MS-Off Ver
    MS365 Version 2304
    Posts
    12

    Re: How to use Index and Match to retrieve data but exlude some other data

    I did. Thank you
    Reply With QuoteRegister To Reply
  8. 06-03-2023, 07:23 PM #8
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: How to use Index and Match to retrieve data but exlude some other data

    The following, placed in J6:J53, replicates the manually placed results in column J6:J14
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  9. 06-05-2023, 09:26 AM #9
    VJo
    VJo is offline
    Registered User
    Join Date
    10-03-2022
    Location
    toronto
    MS-Off Ver
    MS365 Version 2304
    Posts
    12

    Re: How to use Index and Match to retrieve data but exlude some other data

    I truly appreciate your hard work to help me out.

    Thank you a lot
    Reply With QuoteRegister To Reply
  10. 06-05-2023, 09:42 AM #10
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: How to use Index and Match to retrieve data but exlude some other data

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
  11. 06-05-2023, 10:51 AM #11
    VJo
    VJo is offline
    Registered User
    Join Date
    10-03-2022
    Location
    toronto
    MS-Off Ver
    MS365 Version 2304
    Posts
    12

    Re: How to use Index and Match to retrieve data but exlude some other data

    i am having a hard time using this formula in the other cells. Is there any tips you can give me on what to keep in mind? Can I use the same formula for the in person columns?
    Reply With QuoteRegister To Reply
  12. 06-05-2023, 11:52 AM #12
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: How to use Index and Match to retrieve data but exlude some other data

    The formula in post #8 is for the online columns, as I thought the in person columns were already populated using formulas, so I didn't attempt to write a formula for them.
    Tuesday online would be:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Thursday online would be:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    I will attempt the in person columns later if someone hasn't already addressed those.
    Reply With QuoteRegister To Reply
  13. 06-05-2023, 12:20 PM #13
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: How to use Index and Match to retrieve data but exlude some other data

    Here is a formula for the Tuesday in person column:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    The row numbers will need to be adjusted for the other in person columns.
    Let us know if you have any questions.
    Reply With QuoteRegister To Reply
  14. 06-05-2023, 01:43 PM #14
    VJo
    VJo is offline
    Registered User
    Join Date
    10-03-2022
    Location
    toronto
    MS-Off Ver
    MS365 Version 2304
    Posts
    12

    Re: How to use Index and Match to retrieve data but exlude some other data

    Everything works great. You made my day today. Thank you
    Reply With QuoteRegister To Reply
  15. 06-05-2023, 04:00 PM #15
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: (Solved) How to use Index and Match to retrieve data but exlude some other data

    You're Welcome and thank you for the feedback. I hope that you have a blessed day.
    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. Index Match :I want to retrieve all data in one column based on criteria shown in picture.
    By manish2303 in forum Excel General
    Replies: 8
    Last Post: 09-02-2019, 04:12 PM
  2. [SOLVED] Using INDEX and MATCH to Retrieve Excel Data
    By marshallmr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2018, 02:14 PM
  3. Using Index and Match to Retrieve Specific Data from Dupicate Rows
    By dfmurphy8 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2016, 02:11 AM
  4. [SOLVED] Retrieve data using index-match formula
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-11-2015, 09:17 PM
  5. [SOLVED] Using the MATCH-INDEX function to retrieve data.
    By APosada2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-11-2015, 08:02 AM
  6. [SOLVED] VBA to perform an index/match function to retrieve data
    By mji006 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-07-2014, 04:23 PM
  7. Index & Match with dynamic list of data : Retrieve data and classify by dates ?
    By vadius in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-23-2013, 02:21 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