Nested IF statement with Vlookup - HELP PLEASE

[janema]

I have been trying to get this formula to work, but keep failing. I want excel to return a BLANK if it is an error or if the data from the source is blank. I am using a vlookup to pull the data so theoretically, if the result is an error ("IFERROR") or if the source data is blank, the end should return blank. So far, I have tried: =IFERROR(VLOOKUP(D210,'06.2022 file'!$B$1:$S$1000,13,FALSE),""),ISBLANK(LOOKUP(D210,'06.2022 file'!$B$1:$S$1000,13,FALSE),"") but it does not work. I also tried: =IFERROR(VLOOKUP(D210,'06.2022 file'!$B$1:$S$1000,13,FALSE),"",ISNA(VLOOKUP(D210,'06.2022 file'!$B$1:$S$1000,13,FALSE),"") but no luck. It returns a "0" when there is data source is blank, but I want it to just also be blank. How do I combine the two formulas without an error?

Please help!

 

[Fluff]

In that case how about

=LET(v,VLOOKUP(D210,'06.2022 file'!$B$1:$S$1000,13,FALSE),IF(ISNA(v),"",IF(v="","",v)))