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 

​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   Read More

​