![]() If you want to output a text value if an error occurs, remember to place “ “ around your text. If_Not_Found (Optional) - You can use this input to control the return value if the lookup value cannot be found (which normally produces a #N/A error). Return_Array - This range input provides an area for XLOOKUP to return a value associated with the Lookup_Value Lookup_Array - This range input provides an area for XLOOKUP to search for the Lookup_Value Lookup_Value - This single-cell input is the value you are trying to lookup using XLOOKUP
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |