=if(isna(vlookup(...), "Predetermined Value", vlookup())

--
HTH...

Jim Thomlinson


"lightbulb" wrote:

I'm trying to do a Vlookup where if it can't find the information in the
specified array, it returns a predetermined value...is there a way to do this?

Thanks!