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!

 

[jasonb75]

You need to write it as

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

My laptop battery just died so I had to finish it on my phone and haven't been able to check the formula in excel, hopefully it is correct or at least close enough that you can figure out any correction it needs.

 

[janema]

You need to write it as

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

My laptop battery just died so I had to finish it on my phone and haven't been able to check the formula in excel, hopefully it is correct or at least close enough that you can figure out any correction it needs.

It just comes back as "FALSE" when I write that formula This formula is driving me nuts! LOL

 

[jasonb75]

That's not the same as the formula i posted, you're missing some double quotes in the middle.

edit: looks like you've moved a couple of bits as well, the = sign in the middle is after the wrong parentheses

 

[janema]

That's not the same as the formula i posted, you're missing some double quotes in the middle.

edit: looks like you've moved a couple of bits as well, the = sign in the middle is after the wrong parentheses

When I tried the original way it gave me an error and wouldn't let me apply it

 

[janema]

You need to write it as

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

My laptop battery just died so I had to finish it on my phone and haven't been able to check the formula in excel, hopefully it is correct or at least close enough that you can figure out any correction it needs.

I slightly changed it and it worked! Thank you so much! YOU ROCK!

 

[HongRu]

I think this formula is just enough for your need no matter the data is blank or the vlookup is error.

=IFERROR(VLOOKUP(D210,'06.2022 file'!$B$1:$S$1000,13,FALSE),"")

 

[janema]

I think this formula is just enough for your need no matter the data is blank or the vlookup is error.

=IFERROR(VLOOKUP(D210,'06.2022 file'!$B$1:$S$1000,13,FALSE),"")

Unfortunately, that formula does not work. It comes back as zero (0) when the source data is blank. I needed it to be blank for error or no source data.

 

[Fluff]

What version of Excel are you actually using?

 

[janema]

What version of Excel are you actually using?

Microsoft Excel for Microsoft 365 MSO (Version 2210 Build 16.0.15726.20188) 64-bit