Forum Discussion
Solved
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),"...
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.