Wednesday, June 04, 2014

Excel vLookup with "Not Found"

Code to perform a vlookup and if a value is not found, state "Not Found"

=IF(ISNA(VLOOKUP(A:A,'Sheet1'!A:X,3,FALSE)),"Not Found", VLOOKUP(A:A,'Sheet1'!A:X,3,FALSE))
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)