So, if you opened a workbook that contains any of these functions in order versions, I will result name #Name?Error 1 Lookup value exceeds 255 charactersError when the cell (or file) is recalculated Conclusion XLOOKUP is an awesome function!
The Name Excel Error How To Find And Fix Name Errors In Excel Excelchat