Forum Discussion
Questions about nested xlookup.
I'm using nested xlookup to populate a cell based on two tested cells. They are defaulting to #NA, but I'd like to have them populate as blank if one or both cells are false but when I try to change ...
If XLOOKUP returns #VALUE error that most probably means that lookup array and return array are of different size. Why so - hard to say without seen sample file.