Xlook up empty cell (repeat)

[ExcelGeek90]

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 

[#2]

@ExcelGeek90 

Use the FILTER function instead. The basic formula would look like this:

=FILTER(return_array,lookup_array="")