EXECL Advanced Search to problems
vlookup function, if not found, then return an error value “# n / a”, Can not find the case, return a null value
= IF (ISERROR (VLOOKUP (“Joe Smith”, A:B , 2,0 )),””, VLOOKUP (“Joe Smith”, A:B, 2,0))
vlookup function, if not found, then return an error value “# n / a”, Can not find the case, return a null value
= IF (ISERROR (VLOOKUP (“Joe Smith”, A:B , 2,0 )),””, VLOOKUP (“Joe Smith”, A:B, 2,0))
Leave a Reply
You must be logged in to post a comment.