Using a nested IFERROR formula

[janema]

I need to add a formula to this to remove ERRORS and bring them back as a BLANK. I tried putting it to the end of this formula, but it didn't work and gave me an error.
Not sure where to add in the formula to make it work. I always get stuck on how to order them and errors. Sigh.


=IF(Q333="","",IF(AE333="",VLOOKUP(Q333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),VLOOKUP(AE333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE)))

 

[Jeffrey Mahoney]

Please try this

=IFERROR(IF(Q333="","",IF(AE333="",VLOOKUP(Q333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),VLOOKUP(AE333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE))),"")

 

[awoohaw]

Your first IF asks if Q333 is blank, and when blank it sends it to the 2nd part of formula And that part asks you to read Q333 to do a look up.... but it must be blank or it would not be in that section of the formula.

 

[awoohaw]

TRY THIS:

= IFERROR(
IF(Q333<>"",
VLOOKUP(Q333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),
IF(AE333 <> "",
VLOOKUP(AE333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE)
"")),
"")

 

[awoohaw]

TRY THIS:

Correction:

= IFERROR(
IF(Q333<>"",
VLOOKUP(Q333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),
IF(AE333 <> "",
VLOOKUP(AE333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE) ,
"")),
"")

 

[Fluff]

Another option

=IF(Q333="","",IF(AE333="",IFNA(VLOOKUP(Q333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),""),IFNA(VLOOKUP(AE333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),"")))

 

[janema]

Thank you so much. I'm going to try these tonight!

 

[awoohaw]

Correction:

I don't think mine willwork. I got crossed up in the TRUE,FALSE argument reading.

 

[janema]

Another option

=IF(Q333="","",IF(AE333="",IFNA(VLOOKUP(Q333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),""),IFNA(VLOOKUP(AE333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),"")))

This worked!!! You ALWAYS save me! Thanks so much.

 

[Fluff]

Glad we could help & thanks fro the feedback.