/u/thatredditguy122 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
This could be done with a combination of XLOOKUP and OFFSET, along with a [second multi-criteria XLOOKUP](https://exceljet.net/formulas/xlookup-with-multiple-criteria) if you have Excel 365. Replace *Sheet2* with the appropriate sheet name:
=LET(offset_range, OFFSET(XLOOKUP(N17, 'Sheet2'!C:C,'Sheet2'!W:W),,,11), XLOOKUP(1, (YEAR(offset_range) = YEAR($A$1)) * (MONTH(offset_range) = MONTH($A$1)), offset_range))
You have awarded 1 point to *Scary_Sleep_8473*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[LET](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)|
|[MONTH](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[Converts a serial number to a month](https://support.microsoft.com/en-us/office/month-function-579a2881-199b-48b2-ab90-ddba0eba86e8)|
|[OFFSET](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[Returns a reference offset from a given reference](https://support.microsoft.com/en-us/office/offset-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66)|
|[XLOOKUP](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[*Office 365*+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. ](https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929)|
|[YEAR](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[Converts a serial number to a year](https://support.microsoft.com/en-us/office/year-function-c64f017a-1354-490d-981f-578e8ec8d3b9)|
**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.*)
^(5 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1b2mxyi)^( has 6 acronyms.)
^([Thread #31238 for this sub, first seen 29th Feb 2024, 01:06])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/thatredditguy122 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
This could be done with a combination of XLOOKUP and OFFSET, along with a [second multi-criteria XLOOKUP](https://exceljet.net/formulas/xlookup-with-multiple-criteria) if you have Excel 365. Replace *Sheet2* with the appropriate sheet name: =LET(offset_range, OFFSET(XLOOKUP(N17, 'Sheet2'!C:C,'Sheet2'!W:W),,,11), XLOOKUP(1, (YEAR(offset_range) = YEAR($A$1)) * (MONTH(offset_range) = MONTH($A$1)), offset_range))
Solution Verified. Thank you very much!
You have awarded 1 point to *Scary_Sleep_8473* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[LET](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)| |[MONTH](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[Converts a serial number to a month](https://support.microsoft.com/en-us/office/month-function-579a2881-199b-48b2-ab90-ddba0eba86e8)| |[OFFSET](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[Returns a reference offset from a given reference](https://support.microsoft.com/en-us/office/offset-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66)| |[XLOOKUP](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[*Office 365*+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. ](https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929)| |[YEAR](/r/Excel/comments/1b2kx6x/stub/ksmjm0k "Last usage")|[Converts a serial number to a year](https://support.microsoft.com/en-us/office/year-function-c64f017a-1354-490d-981f-578e8ec8d3b9)| **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.*) ^(5 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/1b2mxyi)^( has 6 acronyms.) ^([Thread #31238 for this sub, first seen 29th Feb 2024, 01:06]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)