#N/A! is ugly

[mdt175]

=LOOKUP(B$4,'Rate Sheet'!$A:$A,'Rate Sheet'!$H:$H)

As some dates in this range are in the past and no longer in the data set, I am getting #N/A. Is there a way to add an IFERROR to this to return "PAST" if dates are in past? Seems simple but perhaps my brain is fried today.

[ConneXionLost]

Try this:

Please Login or Register  to view this content.

Cheers,