Forum Discussion

ExcelGeek90's avatar
ExcelGeek90
Brass Contributor
Jun 06, 2024

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 

Resources