Hello,
I have this formula in cell AN2,
=IFERROR(FILTER(NameGiftsUnique!$D:$I,NameGiftsUnique!$B:$B=D2,""),"")
if the cell D2 is empty, I am getting a #SPILL! warning but the correct value is showing if the cell D2 is populated. I am using filter to remove the #SPILL! but if I could prevent the message from occurring. It would be more productive.
Tx for your help,
Yves
Bookmarks