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 ...
It's a little difficult to follow exactly what your current formula must look like, as well as what you want to be blank. So if what I'm going to suggest doesn't make sense, please return and post a copy of the spreadsheet itself....
What I'd suggest is surrounding your existing formula with an IFERROR function, so it would look something like this =IFERROR((whatever_you_already_have),"")