Blake Ekelund
Excel
FP&A
Web Dev
Blog
Off the clock
Search
Ctrl K
Say hi
→
Loading...
Safe XLOOKUP – Excel LAMBDA | Blake Ekelund
Excel Toolkit
›
Safe XLOOKUP
Safe XLOOKUP
Lookup
Intermediate
Wrapper for XLOOKUP that returns "" instead of #N/A.
LAMBDA(lookup, array, return_array, IFERROR(XLOOKUP(lookup, array, return_array), "") )
Parameters
lookup
array
return_array
Example Usage
=SAFE_XLOOKUP("Apple", A:A, B:B)
Pro Tips
Add a default value argument for flexibility
Common Issues
Will still error if arrays mismatch in size