Nice one. The XLOOKUP version needs no IFNA at all since "Not found" is its own 4th argument, and the 5th argument (match_mode 2) turns on wildcard matching when you need partial codes.
November 4, 2026 at 12:18 PM
Nice one. The XLOOKUP version needs no IFNA at all since "Not found" is its own 4th argument, and the 5th argument (match_mode 2) turns on wildcard matching when you need partial codes.
And because I'm a little weirdo, I'm also including this one for #bookqw.
Love Excel but still using VLOOKUP and IF? Then this is the book for you.
Available in print and ebook on all major retailers and via libraries: books2read.com/e24newerfn
Love Excel but still using VLOOKUP and IF? Then this is the book for you.
Available in print and ebook on all major retailers and via libraries: books2read.com/e24newerfn
![On the left is the cover for the Easy Excel 2024 Essentials title Newer Functions by M.L. Humphrey with an image of a pie chart and bar graph.
On the right is the following text:
The XLOOKUP Function
Notation: XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
Excel Definition: Searches a range or an array for a match and returns the corresponding item from a second range or array. By default, an exact match is used.
I love this function so much I’m pretty sure I proposed marriage to whoever created it in one of my books. (Not seriously, of course. That would be the bad kind of weird and none of us want to be that.)
Anyway. XLOOKUP lets you take a value, the lookup_value, and then look in a range of cells, the lookup_array, to return a result from a designated range of cells that match up to the lookup array, the return_array.](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:c3cpffdnrmkfeczcezichwf7/bafkreidebjrvlcyg3lpdobfv574n27pqi6ek364zxux55v4gwo6mfeuqvi)
October 28, 2026 at 3:48 PM
And because I'm a little weirdo, I'm also including this one for #bookqw.
Love Excel but still using VLOOKUP and IF? Then this is the book for you.
Available in print and ebook on all major retailers and via libraries: books2read.com/e24newerfn
Love Excel but still using VLOOKUP and IF? Then this is the book for you.
Available in print and ebook on all major retailers and via libraries: books2read.com/e24newerfn
Re: [PATCH] perf: Add match_mode support for --symfs option Ian Rogers writes: (Summary) On Sat, Feb 28, 2026 at 2:06=E2=80=AFAM duchangbin = wrote: I'll send patc...
Origin | Interest | Match
Origin | Interest | Match
Awakari App
awakari.com
March 1, 2026 at 1:39 AM
Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. Download this free, safe, interactive workbook. www.atlaspm.com/toms-tutoria...
Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. – Tom Urtis
www.atlaspm.com
October 28, 2025 at 2:42 AM
Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. Download this free, safe, interactive workbook. www.atlaspm.com/toms-tutoria...
Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. Download this free, safe, interactive workbook. www.atlaspm.com/toms-tutoria...
Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. – Tom Urtis
www.atlaspm.com
October 22, 2025 at 3:12 PM
Tom’s Tutorials For Excel: Using XLOOKUP’s match_mode argument for lookups with mathematical operations for one formula. Download this free, safe, interactive workbook. www.atlaspm.com/toms-tutoria...
Tom’s Tutorials For Excel: Understanding the XLOOKUP function’s match_mode optional fifth argument for exact and inexact matches. A free, safe, downloadable interactive workbook is included! www.atlaspm.com/toms-tutoria...
Tom’s Tutorials For Excel: Understanding the XLOOKUP function’s match_mode optional fifth argument for exact and inexact matches. – Tom Urtis
www.atlaspm.com
May 28, 2025 at 1:21 PM
Tom’s Tutorials For Excel: Understanding the XLOOKUP function’s match_mode optional fifth argument for exact and inexact matches. A free, safe, downloadable interactive workbook is included! www.atlaspm.com/toms-tutoria...
Understanding the XLOOKUP function's match_mode optional fifth argument for exact and inexact matches. #MSExcel #ExcelTips
February 20, 2025 at 4:11 PM
Understanding the XLOOKUP function's match_mode optional fifth argument for exact and inexact matches. #MSExcel #ExcelTips
I guess I thought “exact match” meant “exact match” 🤪
November 21, 2024 at 3:37 PM
I guess I thought “exact match” meant “exact match” 🤪
Cinder v0.5.0 has been released, with fixes for array fields including a new `match_mode` option - select records where any or all of the array values match the filter! hexdocs.pm/cinder/
![A screenshot of code showing the new `match_mode` option for multi select fields.
```
<Cinder.Table.table resource={MyApp.Book} actor={@current_user}>
<:col
field="tags"
filter={:multi_select}
filter_options={[
options: [
{"Fiction", "fiction"},
{"Bestseller", "bestseller"},
{"Award Winner", "award_winner"},
{"New Release", "new_release"}
],
match_mode: :all # Records must contain ALL selected tags
]}
>
```](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:hz26vupnmepf3efzdarz7dmz/bafkreigqfflb545pb6xvsxc2rsiqjzash5dgqithtitlayezmsuvdmyk7a)
July 26, 2025 at 7:20 AM
Cinder v0.5.0 has been released, with fixes for array fields including a new `match_mode` option - select records where any or all of the array values match the filter! hexdocs.pm/cinder/
Built In Introduces Innovative Job Search Tools Enhancing User Experience and Hiring Success#USA#Chicago#Built_In#Match_Mode#Job_Tracker
Built In Introduces Innovative Job Search Tools Enhancing User Experience and Hiring Success
Discover Built In's new AI-driven tools, Match Mode and Application Tracker, designed to revolutionize job searching for tech professionals and improve hiring.
third-news.com
May 8, 2025 at 1:50 PM
Built In Introduces Innovative Job Search Tools Enhancing User Experience and Hiring Success#USA#Chicago#Built_In#Match_Mode#Job_Tracker
Regex also coming to XLOOKUP and XMATCH, which is possible just by adding another option to the match_mode argument.
May 21, 2024 at 1:22 AM
Regex also coming to XLOOKUP and XMATCH, which is possible just by adding another option to the match_mode argument.