Your formula is looking for the text string #N/A (the quote marks tell it to
look for a text string).

Try =IF(ISNA(K2),"SPARE",)
--
David Biddulph

"mcmilja" wrote in message
...
Hello,

Is there an alternative for the Vlookup function output of #N/A when data
is
not found? The reason I ask is because I need to use an If function based
on
the Vlookup output if the data is not found such as
=IF(K2="#N/A","SPARE",)
but the function does not recognize #N/A.

Thanks!
Jaret