Forum Discussion
Return blank if xlookup returns blank
RIght now B11 is returning a result from a blank cell, what I want is for it to return blank if C11 is Blank This is what i'm currently using =IFNA(XLOOKUP($C11,'File Dump'!D:D,'File Dump'!B:B),"...
I've also tried
=XLOOKUP(C2&1,'File Dump'!D:D&--('File Dump'!B:B<>""),'File Dump'!B:B)
The Issue is there's a formula in the C column that seems to be the primary issue.
=XLOOKUP(C2&1,'File Dump'!D:D&--('File Dump'!B:B<>""),'File Dump'!B:B)
The Issue is there's a formula in the C column that seems to be the primary issue.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Here's a test file that has the same formulas and similar set of data.
