=if(isna(vlookupformula),"closed",vlookupformula)

If this post helps click Yes
---------------
Jacob Skaria


"Natalie" wrote:

Hi

I want to say if a vlookup returns a value put that value, and if it returns
#N/A, then put "CLOSED"

Can this be done?

Natalie