Share via

XLookup Return Array Issues

Anonymous
2024-09-27T23:00:10+00:00

Hi all,

I am having issues with my formula returning results that have my look up value and also the ones that do not. I have multiple of the same values in the lookup array that I needed listed together. I finally have the return array the way I want but when I drag to copy the array it's returning all results. What can I do to list only the items that say missing together and the same with the issues?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-09-28T01:31:49+00:00

    This is the results I want:

    From this data:

    When I am creating the formula I am using XLookup and dragging to copy. These are the 2 formulas I am using. I need them to group all the same instances together.

    =XLOOKUP("Missing", TCAC!$E$14:$E$47,TCAC!B14:B47&" "&TCAC!D14:D47&" "&TCAC!F14:I47, "")

    =XLOOKUP("Incomplete-Issues Outstanding", TCAC!$E$14:$E$47,TCAC!B14:B47&" "&TCAC!D14:D47&" "&TCAC!F14:I47, "")

    When I post both of these it finds the first instance but copies everything below it even if it does not have the lookup value.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-09-28T00:14:14+00:00

    I will work on this shortly. Thank you.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-09-28T00:06:22+00:00

    Here are the sheets and formula

    Was this answer helpful?

    0 comments
  4. Ashish Mathur 102K Reputation points Volunteer Moderator
    2024-09-27T23:12:14+00:00

    Hi,

    Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.

    Was this answer helpful?

    0 comments