IFERROR Formula with IF and VLookup Statements

[Thatgirl13]

I'm new to Excel Forum and looking for some help with a nested formula. I'm trying to perform a VLOOKUP on a Position ID to pull a date that is then performing calculations to give a Status based on a set of criteria. I'm able to do that using the nested IF & VLOOKUP formulas. What I'm having trouble with is adding in the IFERROR formula to populate "No Data" instead of #N/A if the Position ID isn't found in the dataset. I've tried a number of IFERROR variations and nothing seems to work.

Here is the nested IF/VLookup which seems to work fine, but I need to add in the correct formula for IFERROR.

=IF(VLOOKUP($A10,$A$1:$D$5,2,FALSE) is less than TODAY(),"Already Delayed",IF(VLOOKUP($A10,$A$1:$D$5,2,FALSE) is less than (TODAY()+$C2+$D2),"Expecting Delay",IF(VLOOKUP($A10,$A$1:$D$5,2,FALSE)is greater than or equal to (TODAY()+$C2+$D2),"On Track"," ")))

Any help provided would be much appreciated.

Thank you!

[BadlySpelledBuoy]

Hi and welcome

Try this.

=IFERROR(IF(VLOOKUP($A13,$A$1:$D$5,2,FALSE)< TODAY(),"Already Delayed",IF(VLOOKUP($A13,$A$1:$D$5,2,FALSE)< (TODAY()+$C5+$D5),"Expecting Delay",IF(VLOOKUP($A13,$A$1:$D$5,2,FALSE) >=(TODAY()+$C5+$D5),"On Track"," "))),"No Data")

BSB

[Thatgirl13]

This worked perfectly! Thank you.

[BadlySpelledBuoy]

Happy to help

BSB