hi,

2 ways

=IF(COUNTIF(A1:A20,F1)0,VLOOKUP(F1,A1:B20,2,FALSE ),"My Pre defined value")

or

=IF(ISNA(VLOOKUP(F1,A1:B20,2,FALSE)),"My pre defined
value",VLOOKUP(F1,A1:B20,2,FALSE))

Mike

"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!