Closed govert closed 4 years ago
Add [if_not_found] as 4th argument of XLookup
[if_not_found]
XLookup
See note at the top of https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376
The extra parameter is now added in version 0.3 - https://github.com/Excel-DNA/XFunctions/releases/tag/v0.3-beta
Add
[if_not_found]
as 4th argument ofXLookup
See note at the top of https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376