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),"...
HansVogelaar Here's a test file that has the same formulas and similar set of data.