Forum Discussion
Xlook up empty cell (repeat)
Hi team, I applied Xlookup and found in my look up array there are some cells which are emptied and in return array there are different values for empty cells. In my result I only see value ...
Use the FILTER function instead. The basic formula would look like this:
=FILTER(return_array,lookup_array="")