Jul 18 2020 01:36 PM - edited Jul 18 2020 01:42 PM
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 the if_not_found of one or both it gives me a #value error.
How can I clean up my spreadsheet to make it look a little easier to read?
Jul 18 2020 02:05 PM
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),"")
Jul 18 2020 02:36 PM
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.
Jul 18 2020 04:44 PM