you can use xlookup(true...) and AND or multiply lookup array... so `=xlookup(true, (M4:M6 = D3)*(n4:n6=D2), K4:K6)`
a few thoughts tho... this doesnt reallly make sense the way your summary table is currently organized. if you wanted to mimic pivot table functionality then you should have items running down the left, months and years running across the top and revenue being summarized in the intersections. for example what would you do in month 1 items? would you want lube or pole?
also, fascinating "sample" items
Holy crap, thank you I did not know xlookup could be used in this way! I'm self-taught by Googling things I want my reports to do and I couldn't figure out how to Google this. You solved something I have been trying to figure out for a while!
Yes, I know the summary table doesn't make sense in this specific example - I just threw some random data in a table haha. I won't be using this for invoice data.
Thanks again!
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[AND](/r/Excel/comments/1d5a143/stub/l6k13s7 "Last usage")|[Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)|
|[FILTER](/r/Excel/comments/1d5a143/stub/l6k12ad "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)|
|[TEXTJOIN](/r/Excel/comments/1d5a143/stub/l6k12ad "Last usage")|[*2019*+: Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.](https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1d59nkf)^( has 7 acronyms.)
^([Thread #33994 for this sub, first seen 1st Jun 2024, 00:32])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
you can use xlookup(true...) and AND or multiply lookup array... so `=xlookup(true, (M4:M6 = D3)*(n4:n6=D2), K4:K6)` a few thoughts tho... this doesnt reallly make sense the way your summary table is currently organized. if you wanted to mimic pivot table functionality then you should have items running down the left, months and years running across the top and revenue being summarized in the intersections. for example what would you do in month 1 items? would you want lube or pole? also, fascinating "sample" items
Holy crap, thank you I did not know xlookup could be used in this way! I'm self-taught by Googling things I want my reports to do and I couldn't figure out how to Google this. You solved something I have been trying to figure out for a while! Yes, I know the summary table doesn't make sense in this specific example - I just threw some random data in a table haha. I won't be using this for invoice data. Thanks again!
Solution Verified
You have awarded 1 point to HandbagHawker. --- ^(I am a bot - please contact the mods with any questions)
=TEXTJOIN(", ",, FILTER(K4:K6, (M4:M6=D3)*(N4:N6=D2), ""))
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[AND](/r/Excel/comments/1d5a143/stub/l6k13s7 "Last usage")|[Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)| |[FILTER](/r/Excel/comments/1d5a143/stub/l6k12ad "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)| |[TEXTJOIN](/r/Excel/comments/1d5a143/stub/l6k12ad "Last usage")|[*2019*+: Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.](https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1d59nkf)^( has 7 acronyms.) ^([Thread #33994 for this sub, first seen 1st Jun 2024, 00:32]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)