Results 1 to 7 of 7

Trouble with INDEX/XLOOKUP

Threaded View

  1. #1
    Registered User
    Join Date
    06-24-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    12

    Trouble with INDEX/XLOOKUP

    Good day!

    I've written a formula (probably quite chunky) to search and compare different cells and return a value if matches found. I have a calendar with clients and week numbers. What is supposed to happen is it searches the data exported from an outlook calendar, matches that info to the client and week number, and if we have a meeting during that week number, return a value of "y" (just so I can do some conditional formatting). My problem is that if there are multiple meetings that week, it only populates one of them, if any at all. I'm not sure how to go about fixing it.

    Screenshot 2023-06-14 133115.png

    My formula is:
    =IFERROR(IF(AND(INDEX('Outlook Calendar Info'!$G:$G,ROW(XLOOKUP($F$5,WeekNumbers,WeekNumbers)))=$B7,YEAR(INDEX('Outlook Calendar Info'!$E:$E,ROW(XLOOKUP($F$5,WeekNumbers,WeekNumbers))))=2023),"y",""),"")


    Any Ideas?
    Attached Files Attached Files
    Last edited by Chavis339; 06-21-2023 at 10:53 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trouble with XLOOKUP - referencing lookup in different sheets
    By Calb1976 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2023, 03:41 AM
  2. [SOLVED] Having trouble using XLOOKUP between two spreadsheet files
    By twalp in forum Excel General
    Replies: 7
    Last Post: 03-02-2023, 06:14 PM
  3. xlookup vs match/Index
    By lastnn30 in forum Excel General
    Replies: 3
    Last Post: 08-05-2022, 03:30 AM
  4. XLOOKUP and INDEX formulas in tandem
    By SergeyZh in forum Excel General
    Replies: 3
    Last Post: 12-28-2021, 04:47 AM
  5. Do I use an INDEX/MATCH function or XLOOKUP for this example?
    By Majestic1976 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-13-2021, 08:57 AM
  6. Index/Match vs Xlookup
    By lastnn30 in forum Excel General
    Replies: 3
    Last Post: 11-28-2021, 01:53 PM
  7. XLOOKUP vs INDEX & MATCH?
    By andrewc in forum Excel General
    Replies: 9
    Last Post: 08-26-2021, 10:59 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