VLOOKUP Condition
Yes, when VLookup() doesn't find a match, it returns #N/A error and you can
test for that:
=IF(ISNA(yourVlookupFormula),predeterminedValue,yo urVlookupFormula)
a real one might look like
=IF(ISNA(VLOOKUP(A1,Sheet2!B9:X109,3,False)),-55,VLOOKUP(A1,Sheet2!B9:X109,3,False))
You could even return text as:
=IF(ISNA(VLOOKUP(A1,Sheet2!B9:X109,3,False)),"No Match
Found",VLOOKUP(A1,Sheet2!B9:X109,3,False))
"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!
|