VLOOKUP Formula HELP

[janema]

I am trying to squeeze in another two formulas into this one, but keep getting an error. I need to add a formula to bring back BLANK if it's an error, and also to bring back a BLANK if the lookup (Q426) field is blank. It keeps telling me too many arguments. The formula currently is:

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

Please help.

 

[Skybluekid]

Try
=IFS(AD426="","",ISNA(VLOOKUP(AD426,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE)),"",TRUE,Q426="","")

 

[janema]

Try
=IFS(AD426="","",ISNA(VLOOKUP(AD426,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE)),"",TRUE,Q426="","")

That didn't work. It returned an error that there were too many arguments.

 

[Skybluekid]

=IFS(AD426="","",ISNA(VLOOKUP(AD426,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE)),"",Q426="","")

That may fix it

 

[janema]

That came back as an error too

I tried this formula:

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

This removed the errors when Q4 is blank, but I need it to return BLANK if there are errors too. This is returning too many arguments too.

 

[janema]

I need to add a formula to this to remove ERRORS as BLANK. I tried putting it to the end of this formula, but it didn't work and gave me an error.

=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)))

 

[Skybluekid]

That came back as an error too

I tried this formula:

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

This removed the errors when Q4 is blank, but I need it to return BLANK if there are errors too. This is returning too many arguments too.

The problem is that the last VLOOKUP is the FALSE for the second IF. Try building your if step by step. Start with the first condition and then add the next condition etc,

 

[janema]

The problem is that the last VLOOKUP is the FALSE for the second IF. Try building your if step by step. Start with the first condition and then add the next condition etc,

I accidentally double posted this. I'll close this one as resolved. Oops.