Monday, 13 April 2015

Two ways to handle NA in Vlookup

Two ways to handle NA in Vlookup


=IFERROR(VLOOKUP(A2,Sheet1!A:B,2,0),"Not exists")

or

=IF(ISNA(VLOOKUP(A2,Sheet1!A:B,2,0)),"NO","YES")
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)