Forum Discussion
ExcelGeek90
Jun 06, 2024Brass Contributor
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 from return array with first empty cell in look up array.
Can someone please help how to see /look empty cells from look up array in return array against different values?
thanks
- Riny_van_EekelenPlatinum Contributor
Use the FILTER function instead. The basic formula would look like this:
=FILTER(return_array,lookup_array="")